Mysql ... really F***ED up

you should learn more about mysql. but, first try disable pconnect in your server php.ini

 

in this case you should give more information to forum visitors - number of mysql processes, mysql variables, number of httpd processes and etc. and even if you post this information here, it may be not help you, because honestly this is mysql optimization problem and it will require most likely access to server and monitoring within a day or more all processes on your server for finding what happen and where problem exist.

 

and if the server is getting enough traffic, all the tweaks in the world might not help you. You may just need a cluster of 300 - 400 machines working together. By asking "please just tell me how to fix it" ..that's not going to help us help you . Unless you want us to say something like use a big hammer and bash it to hell until you see no more lights and no more sound. That should fix the mysql problem for you.

 

Someone's really screwed up your MySQL server.

In this order :

Stop mysql conventionally : /etc/rc.d/init.d/mysql stop

Be sure it died : ps auxw | grep mysql

You may have to kill a out of control process. Your system may have plenty of ram but something is telling me that one particular mysql child has taken a major footprint in the cache preventing your restart or other children from forking. I'd need to see the output of your ps or top screen to tell you.

If its NOT dead, you can try it with a killall (signal 9 , term, etc .. ) then try re-starting.

Because its been hosed a bit, I then recommend (at the least)

tar -czvf /var/lib/mysql/mysql/*.MYI /root/mysql.system.backup.tar.gz

once done

myisamchk -r /var/lib/mysql/mysql/*.MYI

(could also try -o)

.. as well as (if possible) doing this on whatever db was being accessed when the problem happened.

Then try re-starting.

Still no good? Post back what's in the .err file named after your system's hostname found in /var/lib/mysql.

Also ensure user/group mysql own everything in /var/lib/mysql

HTH