Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I host my websites on a server that has some problems with MySQL. Looking at PHPMyAdmin statistics tab, I see these stats:

PHPMyAdmin stats

It shows that 99.68% connections have beed aborted. I googled a little bit about it, but I can't figure out what it really means. What is the reason for this and how can it be fixed?

share|improve this question
add comment

2 Answers 2

up vote 2 down vote accepted

See http://dev.mysql.com/doc/refman/5.1/en/communication-errors.html

An aborted connection is one that:

  • didn't call mysql_close
  • timed out
  • had some real error

I'm guessing from the very high rate that you're creating connections to the database but not closing them when you're finished with them.

share|improve this answer
    
Thanks. Do you know whether PHPMyAdmin reports Aborted Connections only or Aborted Clients (which are listed on the page you wrote about) as well? –  Milan Babuškov May 12 '10 at 21:13
add comment

The most common reason for an aborted connection is bad coding. Programs open the connection but don't close it when they're done. Just sloppy programming.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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