xplanedotorg Posted February 18, 2014 Share Posted February 18, 2014 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. Link to comment Share on other sites More sharing options...
Rhett Posted February 18, 2014 Share Posted February 18, 2014 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 Link to comment Share on other sites More sharing options...
xplanedotorg Posted February 19, 2014 Author Share Posted February 19, 2014 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. Link to comment Share on other sites More sharing options...
Rhett Posted February 19, 2014 Share Posted February 19, 2014 If you don't get anything at 10 seconds after 24 hours, drop it to 5 seconds. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.