question Re: Ambari UI is responding very Slow in Support Questions

Ambari UI is responding very Slow

saivenkatg55 — Thu, 31 Oct 2019 14:16:30 GMT

Ambari UI is running slow. Currently, the cluster size is 6 nodes

Re: Ambari UI is responding very Slow

saivenkatg55 — Thu, 31 Oct 2019 11:57:47 GMT

Especially while clicking the services tab like hdfs config etc and it became normal after ambari server restart. Kindly help me to fix this issue.

Re: Ambari UI is responding very Slow

Shelton — Thu, 31 Oct 2019 14:02:08 GMT

@saivenkatg55

This is nor a silver bullet but worth trying,your ambari database could be overwhelmed scanning through old data to help you narrow down the problem please do the below steps

Stop the Ambari Server by using ambari-server stop.
# ambari-server stop

Run db-purge-history
Use the cotrrect data format for your server

# ambari-server db-purge-history --cluster-name [PROD] --from-date 2016-04-01

Start the Ambari Server: by using ambari-server start .
# ambari-server start

Ref: Tuning Ambari server performance

Please revert l

Re: Ambari UI is responding very Slow

saivenkatg55 — Tue, 12 Nov 2019 09:30:55 GMT

@Shelton which date we need to use in the from-date parameter?

Re: Ambari UI is responding very Slow

Shelton — Tue, 12 Nov 2019 09:44:16 GMT

@saivenkatg55

The example I gave purges history records created before First of April 2016 for the cluster named [PROD].

You could safely delete data from last month if you Cluster is named PROD

# ambari-server db-purge-history --cluster-name [PROD] --from-date 2019-10-31

Re: Ambari UI is responding very Slow

sagarshimpi — Tue, 12 Nov 2019 10:21:40 GMT

Can you also check heap size utilization for Ambari server. You might need to revisit Ambari server heap config if needed.

Check this link for details - https://docs.cloudera.com/HDPDocuments/Ambari-2.7.4.0/administering-ambari/content/amb_adjust_ambari_server_heap_size.html

Re: Ambari UI is responding very Slow

Shelton — Wed, 27 Nov 2019 13:34:17 GMT

@saivenkatg55

Any updates your feedback will be appreciated.

Re: Ambari UI is responding very Slow

saivenkatg55 — Thu, 28 Nov 2019 11:12:46 GMT

@Shelton I could see some improvement on the UI, after clearing the DB old logs

Re: Ambari UI is responding very Slow

Shelton — Thu, 28 Nov 2019 12:23:46 GMT

@saivenkatg55

Great, can you gauge the improvement in percentage? Can you back up your ambari.properties and make the below changes to further enhance the Ambari performance I usually script that as a post-install step.

Can you then take time and Accept the solution and close the thread so other members can reference it should they encounter a simpler situation.

Purging in the Ambari database from time to time should be an Admin maintenance task

Backup the ambari server properties file

# cp /etc/ambari-server/conf/ambari.properties /etc/ambari-server/conf/ambari.properties.ORIG

Change the timeout of the ambari server

# echo 'server.startup.web.timeout=120' >> /etc/ambari-server/conf/ambari.properties
# echo 'server.jdbc.connection-pool.acquisition-size=5' >> /etc/ambari-server/conf/ambari.properties
# echo 'server.jdbc.connection-pool.max-age=0' >> /etc/ambari-server/conf/ambari.properties
# echo 'server.jdbc.connection-pool.max-idle-time=14400' >> /etc/ambari-server/conf/ambari.properties
# echo 'server.jdbc.connection-pool.max-idle-time-excess=0' >> /etc/ambari-server/conf/ambari.properties
# echo 'server.jdbc.connection-pool.idle-test-interval=7200' >> /etc/ambari-server/conf/ambari.properties

Hope that helps

Happy hadooping

Re: Ambari UI is responding very Slow

saivenkatg55 — Thu, 05 Dec 2019 08:20:31 GMT

Sure @Shelton

Re: Ambari UI is responding very Slow

Shelton — Tue, 10 Dec 2019 01:41:41 GMT

@saivenkatg55

Please don't forget to vote a helpful answer and accept the best answer.

If you found this answer addressed your initial question, please take a moment to login and click "accept" on the answer.

Re: Ambari UI is responding very Slow

saivenkatg55 — Thu, 30 Jan 2020 12:14:47 GMT

@Shelton we are still experiencing slowness in ambari UI after enabling the above properties.