Mysql Errors

I just wanted to make a list of some mysql related errors and hopefully some simple ways to solve them. Mysql usually will show an error on the page when trying to load it, but you may need to turn on errors in your site (search for something like “turning on errors in Joomla/Wordpress/etc”) or you can check the mysql error log which is usually in /var/lib/mysql/ as the hostname of the server and ending in .err.


140916 12:44:25 [ERROR] Error in accept: Too many open files

To fix try editing the /etc/my.cnf file through ssh

vim /etc/my.cnf

look for a line that shows “open_files_limit”. If it’s not there just add it. I usually set this to:

open_files_limit=20000

then save the file by pressing the Escape Key then typing :wq

After you get back to the command prompt, restart mysql:

service mysql restart


 

More to come later