One of my websites had too many MySql connections, I did some performance in the scripting and shutdown some expensive queries to make the website more reachable again.
Because my processlist was full for 100% with queries, I thought it will help the server to restart mysql (to response fast again).
No I tried to shutdown mysql and it said it will. But after 10minutes the command seems to be freezed, no more reaction I saw. I quit by ctrl+x and I though to try the mysql stop command again, failure!. I am also not able to start mysql.
If you take a look at the command 'top' it gives me some serious bad mysql CPU results.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 28429 mysql 20 0 356m 128m 6336 S 88.2 6.4 1095:39 mysqld
I hope some can help me with this one!