您好,欢迎访问一九零五行业门户网

MySQL性能提议者:mysqltuner.pl

mysql性能建议者:mysqltuner.pl [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 mysqltun
mysql性能建议者:mysqltuner.pl
[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 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.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 properly
variables to adjust:
    query_cache_size (>= 8m)
    thread_cache_size (start at 4)
    innodb_buffer_pool_size (>= 184m)
输出结果简单明了,读者有兴趣可参阅官网博客
by 迦夜
2013-10-23
happy databasing
其它类似信息

推荐信息