MySql help! Willing to pay...

Hi, I have a dedicated server running apache + mysql.

The mysql database has been crashing on a daily basis lately, I tried all sorts of tweaking like setting the max_connection higher, persistent connection to off, but it's still crashing. Also when the database crashes I'm unable to access through SSH neither.

Could someone please fix it up for me? Willing to pay, thanks.

 

If this is due to MySQL then you may need to optimize your MySQL configuration file. Below link will help you to set optimized settings:

http://www.t-scripts.com/mysql/

Also I suggest you to look in Apache error logs too and monitor your server load on regular basis. Check the CPU usage of running process when the load goes high.

Kailash

 

Have you tried optimizing the queries who runs on the database? And do you have appropriate indexes?

 

You should post this in BST section at services.

 

If you're unable SSH in when this happens, that suggests a more system-wide problem than just mysql. Maybe the machine is running out of memory or disk space, or perhaps there is some filesystem corruption or hardware problem... Can you see whether there's anything out of the ordinary in your system logs?