The MySQL query lost connection

Especially frequent queries a database, you will receive an error message ID, 2013; query process connection lost,

The query is not very slow speed, is particularly frequent, ,

Environment: the server and the database deployment on the same machine,

Started by Omar at November 30, 2016 - 1:55 AM

Wonder is it right? Frequent operation resulted in too many files open
It is recommended that you review
Frequent operands connected view of the MySQL and other parameters, to see whether it has reached the limit

Posted by Ritchie at December 11, 2016 - 2:27 AM

show processlist;

Posted by Karen at December 20, 2016 - 2:52 AM

From the server to check the error log.

Posted by Sheryl at December 27, 2016 - 3:07 AM

Implementation of ulimit -n 65535
Then add in the /etc/security/limits.conf and add the following two rows
* soft nofile 65535
* hard nofile 65535

Posted by Vic at January 11, 2017 - 3:19 AM