mysql mysqltuner.pl_MySQL性能建议者：mysqltuner.pl

MySQL性能建议者：mysqltuner.pl

性能mysql

[root@even ~]# wget https://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 https://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)