Jump to content

MySQL Errors

Recommended Posts

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

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


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...