There should be a way for MySQL to log the connections that get aborted. At least it will tell you if it was the client that aborted the connection.
On 4/18/13 6:16 AM, "benoit lair" <kurushi4...@gmail.com> wrote: >Hello, > > >I'm using a cs 4.0.0 preproduction server onto centos 5.3. > >I have launched a mysqltuner.pl onto the mysql server of the mgmt server. > >So it gives me connections aborted. > >Have you an explication why it show this ? How can i troubleshoot this ? > >Here is my mysqltuner.pl output : > >[root@cloudstack-master-server ~]# ./mysqltuner.pl > > >> MySQLTuner 1.2.0 - Major Hayden <ma...@mhtx.net> > >> Bug reports, feature requests, and downloads at >http://mysqltuner.com/ > >> Run with '--help' for additional options and output filtering >Please enter your MySQL administrative login: root >Please enter your MySQL administrative password: > >-------- General Statistics >-------------------------------------------------- >[--] Skipped version check for MySQLTuner script >[OK] Currently running supported MySQL version 5.1.67-log >[OK] Operating on 64-bit architecture > >-------- Storage Engine Statistics >------------------------------------------- >[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster >[--] Data in InnoDB tables: 23M (Tables: 166) >[--] Data in MEMORY tables: 125K (Tables: 2) >[!!] Total fragmented tables: 166 > >-------- Security Recommendations >------------------------------------------- >[OK] All database users have passwords assigned > >-------- Performance Metrics >------------------------------------------------- >[--] Up for: 7m 46s (79K q [169.689 qps], 16 conn, TX: 20M, RX: 6M) >[--] Reads / Writes: 93% / 7% >[--] Total buffers: 66.0M global + 3.6M per thread (350 max threads) >[OK] Maximum possible memory usage: 1.3G (13% of installed RAM) >[OK] Slow queries: 0% (0/79K) >[OK] Highest usage of available connections: 2% (10/350) >[OK] Key buffer size / total MyISAM indexes: 8.0M/92.0K >[OK] Key buffer hit rate: 100.0% (24 cached / 0 reads) >[OK] Query cache efficiency: 28.7% (7K cached / 25K selects) >[OK] Query cache prunes per day: 0 >[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 844 sorts) >[!!] Joins performed without indexes: 35 >[OK] Temporary tables created on disk: 1% (12 on disk / 936 total) >[!!] Thread cache hit rate: 37% (10 created / 16 connections) >[OK] Table cache hit rate: 92% (128 open / 138 opened) >[OK] Open file limit used: 0% (12/1K) >[OK] Table locks acquired immediately: 100% (7K immediate / 7K locks) >[!!] Connections aborted: 12% >[OK] InnoDB data size / buffer pool: 23.1M/24.0M > >-------- Recommendations >----------------------------------------------------- >General recommendations: > Run OPTIMIZE TABLE to defragment tables for better performance > MySQL started within last 24 hours - recommendations may be inaccurate > Enable the slow query log to troubleshoot bad queries > Adjust your join queries to always utilize indexes > Your applications are not closing MySQL connections properly >Variables to adjust: > join_buffer_size (> 1.0M, or always use indexes with joins) > thread_cache_size (> 4) > > >Thanks for any advice. > > >Regards, Benoit.
