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.

When I run mysqltuner it is showing the error in the title. Please help me to solve it.

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.61-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 1G (Tables: 1413)
[--] Data in InnoDB tables: 4M (Tables: 199)
[!!] Total fragmented tables: 257

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 4h 33m 39s (17M q [1K qps], 1M conn, TX: 16B, RX: 1B)
[--] Reads / Writes: 92% / 8%
[--] Total buffers: 1.0G global + 2.7M per thread (256 max threads)
[OK] Maximum possible memory usage: 1.7G (11% of installed RAM)
[OK] Slow queries: 0% (7/17M)
[OK] Highest usage of available connections: 84% (216/256)
[OK] Key buffer size / total MyISAM indexes: 8.0M/2.0G
[OK] Key buffer hit rate: 97.7% (2B cached / 68M reads)
[OK] Query cache efficiency: 76.3% (10M cached / 14M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (958 temp sorts / 475K sorts)
[OK] Temporary tables created on disk: 6% (22K on disk / 343K total)
[OK] Thread cache hit rate: 83% (188K created / 1M connections)
[OK] Table cache hit rate: 89% (3K open / 3K opened)
[OK] Open file limit used: 65% (4K/6K)
[OK] Table locks acquired immediately: 99% (4M immediate / 4M locks)
[!!] Connections aborted: 74%
[OK] InnoDB data size / buffer pool: 4.2M/8.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Your applications are not closing MySQL connections properly
share|improve this question
add comment

closed as not a real question by Chris S Apr 30 '12 at 13:45

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

Well, your applications are not closing MySQL connections properly. Do they ever call something like mysql_close($connection) (PHP), $databaseconnection->disconnect; (Perl) or similar? We here at serverfault.com can't possibly know that without seeing your application source code. :-)

share|improve this answer
    
I don't know actually what are they calling, when i run mysqltuner the error is showing, but yesterday i did not see this error. –  Barkat Ullah Apr 30 '12 at 13:04
    
Then someone has updated the application, the database or something else. –  Janne Pikkarainen Apr 30 '12 at 13:07
    
Is it related to /etc/my.cnf configuration? Cause i have only changed my.cnf configuration –  Barkat Ullah Apr 30 '12 at 13:13
    
Impossible to know without you showing us the changes between your old and new my.cnf ... anyway I'm still suspecting the applications. –  Janne Pikkarainen Apr 30 '12 at 13:15
add comment

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