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.