bitscn.com
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)
bitscn.com