MySQL server not starting – Part 3

A common issue when MySQL versions are upgraded is the presence of depreciated commands in /etc/my.cnf that would prevent MySQL from restarting.  Other than the presence of depreciated ones, incomplete commands too can cause the issues. When MySQL is upgraded to 5.5...

MySQL server not starting – Part 2

There are ton’s of causes for which MySQL might not start, ranging from disk space full ( highlighted here ) to databases getting corrupt. First place where you have to check for a clue is the .err log – ( /var/lib/mysql/hostname.err ) If the err corresponds to...

Memory drain issues on MySQL 5.6 ?

With the recent upgrade of WHM/cPanel, the users get the ability to upgrade their MySQL server to 5.6.x ( x > 6 ). However, when this upgrade is done, lot of server owners are seeing memory drainage issues. An idle MySQL server tends to consume around 50% of your...

MySQL server not starting !

When trying to start MySQL server, are you facing this error : “Timeout error occurred trying to start” Check for the MySQL logs to see if you can track something. # /var/log/mysqld.log or /var/lib/mysql/hostname.err ( whichever is the log location ) and...