3

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

1
2

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:

1
  • Thanks for your reply. Do you know if these sorts of connection errors would effect availability? The strange thing is the the web application did not thow any errors and only four transactions were affected. Prior to this issue, the site ran fine for three weeks, so to my mind that really points the finger at the MySQL server.
    – Kokako
    Apr 22 '15 at 8:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.