This morning, when testing the code, I found that it always timed out when I was writing MySQL, and then failed, using the MySQL command
Show Processlist;
found that two update SQL statements have been executed for a long time, that the two programs to lock the table, and then ready to kill the two requests, kill several times is a failure, so decided to restart MySQL. But restarting the connection to MySQL again found not connected, the error is as follows:
2002 (HY000): Can'/var/lib/mysql/mysql.sock'
Then use the command to see if MySQL is really up.
PS -a| grep MySQL
View, two processes are started, look is normal, but the view port found that 3306 port does not open, what problem???
Go ahead and look at what state MySQL is currently in.
Service MYSQLD Status
The output is not what you just thought:
MySQL is running but PID file could not being found
There are netizens prompt to kill the MySQL process, and then restart, try, invalid.
View the MySQL error log, which displays the following information:
' ./mysql-bin.~rec~ ' - for Free - for server to continue after freeing disk space)
The original disk is insufficient, clean up the next disk is OK.
Can ' t connect to local MySQL server through socket