Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Knowledge Base

Why does the Controller take longer to start when App Server and MySQL are restarted?

In a large MySQL database with numerous tables and partitions, the information_schema.partitions table is built serially and is cached once built. This is so the App Server can be restarted quickly if the database is not also restarted.


For this reason, it is not recommended to restart the database unless absolutely necessary.


To track how long the Controller takes to start, run the following command from the computer terminal during startup repeatedly at two-minute intervals until the Controller UI is accessible:


echo "select time, info from information_schema.processlist where command = 'Query' and user != 'root';" | <controller_home>/bin/ login-db 


If the results include the information_schema.partitions, the Controller is building the list of partitions and the Controller UI would not be accessible yet.


If frequent database restarts are necessary, the amount of time to start can be improved by adding the innodb_stats_sample_pages=1 property to the end of the <controller_home>/db/db.cnf file (after "# End of standard db.cnf" ) if it does not exist already and restarting the Controller.


This property is added by default for High Availability Controller Deployments.




# End of standard db.cnf
# added to speed up startup


Version history
Last update:
‎10-09-2018 09:10 AM
Updated by:
By replying you agree to the Terms and Conditions of the AppDynamics Community.
0 Kudos
For some reason, the page won't let me select the text of the SQL to check how long Controller start-up takes. The box in which the statement beginning 'echo "select time...' appears to be non-reactive in terms of the apparent horizontal scrollbar too.

Hi Marcus,


I can confirm, using Chrome the box does not scroll horizontally. Looks like we have a bug in our new community redesign. I'll file a ticket with our team, and then change the formatting so that you're able to copy the text.