Mysql slow to restart

[MarceloKonrath]

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]

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.

 

[cPanelMichael]

Hello

Also, try running "mysqladmin processlist" to see if any databases or tables are using excessive resources.

Thank you.

 

[TerranceR]

You may want to let MySQL run for awhile (a day or 2) and then run mysqltuner.pl http://mysqltuner.pl tuning your my.cnf may help quite a bit in this case.