MySQL性能建议者：mysqltuner.pl_MySQL

MySQL性能建议者：mysqltuner.pl

性能mysql

[root@even ~]# wget  http://mysqltuner.pl/mysqltuner.pl[root@even ~]# chmod +x mysqltuner.pl [root@even ~]# cp mysqltuner.pl /home/mysql/

一些简单的命令可从 --help 查阅

[mysql@even ~]$ ./mysqltuner.pl  >>  MySQLTuner 1.2.0 - Major Hayden  >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/ >>  Run with '--help' for additional options and output filteringPlease enter your MySQL administrative login: rootPlease enter your MySQL administrative password: -------- General Statistics --------------------------------------------------[--] Skipped version check for MySQLTuner script[OK] Currently running supported MySQL version 5.5.16-log[OK] Operating on 32-bit architecture with less than 2GB RAM-------- Storage Engine Statistics -------------------------------------------[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 7B (Tables: 2)[--] Data in InnoDB tables: 184M (Tables: 7)[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)[!!] Total fragmented tables: 5-------- Security Recommendations  -------------------------------------------[!!] User '@even.example.com' has no password set.[!!] User '@localhost' has no password set.[!!] User 'root@127.0.0.1' has no password set.[!!] User 'root@::1' has no password set.[!!] User 'root@even.example.com' has no password set.-------- Performance Metrics -------------------------------------------------[--] Up for: 10s (9 q [0.900 qps], 6 conn, TX: 10K, RX: 625)[--] Reads / Writes: 100% / 0%[--] Total buffers: 176.0M global + 1.6M per thread (151 max threads)[OK] Maximum possible memory usage: 411.9M (38% of installed RAM)[OK] Slow queries: 0% (0/9)[OK] Highest usage of available connections: 0% (1/151)[OK] Key buffer size / total MyISAM indexes: 16.0M/98.0K[!!] Query cache is disabled[OK] Temporary tables created on disk: 0% (0 on disk / 2 total)[!!] Thread cache is disabled[OK] Table cache hit rate: 78% (26 open / 33 opened)[OK] Open file limit used: 2% (21/1K)[OK] Table locks acquired immediately: 100% (36 immediate / 36 locks)[!!] Connections aborted: 16%[!!] InnoDB data size / buffer pool: 184.8M/128.0M-------- Recommendations -----------------------------------------------------General recommendations:    Run OPTIMIZE TABLE to defragment tables for better performance    MySQL started within last 24 hours - recommendations may be inaccurate    Set thread_cache_size to 4 as a starting value    Your applications are not closing MySQL connections properlyVariables to adjust:    query_cache_size (>= 8M)    thread_cache_size (start at 4)    innodb_buffer_pool_size (>= 184M)