Mysql – Strange Availability Problem with MySQL

MySQL

I am trying to troubleshoot an e-commerce site problem that seems to be database related. In my investigation so far, I noticed that the server seems to have an unusually high numbers relating to Aborted_clients: 65206
and Aborted_connects: 394618

This is on a server that was restarted two weeks ago.

I'm not a DBA, but I suspect that this has something to do with the issue. Can anyone fill me in on what these values mean and if it could be causing availability issues?

Thanks

Best Answer

From the MySQL Documentation

  • Aborted_clients : The number of connections that were aborted because the client died without closing the connection properly.
  • Aborted_connects : The number of failed attempts to connect to the MySQL server

From the look of those two status variables: