I have found a way to prevent server overload because of MySQL. The tip seems to be really good, and I am giving the link to the original post. Here it is: Dramatically Improve MySQL Performance

In order to make your heavy MySQL servers perform faster all you need is to add a line to your MySQL configuration file: my.cnf.

max_write_lock_count = 1

This line should be added under [mysqld] section of my.cnf. I won’t describe what does this setting actually do as you’re welcome to read it in the original post. I just want to say that this little string greatly increases your MySQL server performance. You’re welcome to try and to get back in your comments.

Tags: improve mysql configuration, improve mysql on heavy servers, max_write_lock_count = 1, mysql max_write_lock_count, mysql performance