February 18, 2014 in Classic self-hosted technical help
Having some issues with mysql 5.5 on a Ubuntu 12.04 LTS server. The server is not taxed. Its running at about 8 - 15% when these occur. About every 5 - 10 minutes I'm seeing two errors.
Error: 2013 - Lost connection to MySQL server during query
Error: 2006 - MySQL server has gone away
Finding many webpages on this subject but often conflicting and vague.
My question is, are others seeing these errors regularly? Is it something to be concerned about? Strange thing is I only see them in the SQL error logs within the ACP.
Thanks for the assistance.
It's hard to guess without looking at your server, check your disk i/o to see if it's high, enable slow query logging, set it to 10 seconds, then provide the results of that here and we can look. Is this a dedicated server? a VPS? etc
It is a dedicated server. I've been tailing that slow query log for about an hour now and nothing has been dumped in it. I also made two changes to my.cnf last night that significantly reduced the issue. I was averaging about 3 MB a day in the ACP SQL error log is now in the K's. The two values I changed were:
max_connections, raised it to 500.
table_cache to 1000.
I did also notice I'm now using some swap space. Using about 332 MB of swap space right now. I'll check that slow query log after work tomorrow and see if anything shows up in it.
If you don't get anything at 10 seconds after 24 hours, drop it to 5 seconds.
This topic is now archived and is closed to further replies.
Pushpendra Singh Chauhan
Started September 28, 2022
Started 9 hours ago
Started November 9, 2021