Become The Solution Chicago Logo

Become The Solution Chicago Logo

Search Become The Solution:

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 102

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 102

If your MySQL service suddenly stopped accepting connections and you receive an error trying to connect to your MySQL server instance, try to increase the connect_timeout variable in the my.cnf file shown below. For more information, refer to the MySQL documentation here.

 

MySQL Error message:

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 102

 

The suggested value to apply is 10 seconds. You can increase to 30 seconds or higher if you continue to receive the error. In addition, you should increase the table_open_cache limit to something less than 1000. See this article for more details.

 

In my.cnf file, add:

connect_timeout = 10
table_open_cache = 900

 

Restart MySQL.

2

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Guest
Sunday, 26 May 2019




Sign-Up to Recieve E-Mail Updates!