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