Ocassionally my mysql is getting stuck. The system think it is running, but users get mysql.sock errors. Since the system thinks it is running, I get no warning. A simple restart does the trick. How can I diagnose this problem? This server has very little activity.
mysql gets stuck
- Thread starter rldev
- Start date
When this happens you can look at this:
netstat -nt | greo 3306 | wc
Then hop into mysqladmin
mysqladmin -u root -p
Then do a processlist and let us know what it prints out. You do need to get you my.cnf but it sound like you may have the wait timeout to high (which it is by default).
netstat -nt | greo 3306 | wc
Then hop into mysqladmin
mysqladmin -u root -p
Then do a processlist and let us know what it prints out. You do need to get you my.cnf but it sound like you may have the wait timeout to high (which it is by default).