Mysql slow to restart

MarceloKonrath

• July 11, 2015 09:33

Hello The restart of MySQL is extremely slow. mysql 5.5.42-cll I see in .err file InnoDB: Reading tablespace information from the .ibd files... And the restart is very very very slow. Starting MySQL.................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................. More than 5 minutes for a restart. Any tips to better it? Thank you Konrath

• 

  geo_grav

  • July 16, 2015 00:38

  Could this be a memory issue, such that processes have been swapped out onto disk. Please let us know the output of the command 'free -m' without the quotes. G.

  0
• 

  cPanelMichael

  • July 16, 2015 14:55

  Hello :) Also, try running "mysqladmin processlist" to see if any databases or tables are using excessive resources. Thank you.

  0
• 

  TerranceR

  • July 17, 2015 03:55

  You may want to let MySQL run for awhile (a day or 2) and then run mysqltuner.pl

  0

Please sign in to leave a comment.