mysql+本地调优工具,MySQL调优工具MySQLTuner

下载：wget http://mysqltuner.pl/ -O mysqltuner.pl

运行：perl mysqltuner.pl 结果：>> MySQLTuner 1.4.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:

[OK] Currently running supported MySQL version 5.5.41-0+wheezy1

[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------

[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM

[--] Data in InnoDB tables: 1M (Tables: 11)

[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)

[!!] Total fragmented tables: 11

-------- Security Recommendations -------------------------------------------

[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------

[--] Up for: 47s (113 q [2.404 qps], 42 conn, TX: 19K, RX: 7K)

[--] Reads / Writes: 100% / 0%

[--] Total buffers: 192.0M global + 2.7M per thread (151 max threads)

[OK] Maximum possible memory usage: 597.8M (60% of installed RAM)

[OK] Slow queries: 0% (0/113)

[OK] Highest usage of available connections: 0% (1/151)

[OK] Key buffer size / total MyISAM indexes: 16.0M/99.0K

[!!] Query cache efficiency: 0.0% (0 cached / 71 selects)

[OK] Query cache prunes per day: 0

[OK] Temporary tables created on disk: 25% (54 on disk / 213 total)

[OK] Thread cache hit rate: 97% (1 created / 42 connections)

[OK] Table cache hit rate: 24% (52 open / 215 opened)

[OK] Open file limit used: 4% (48/1K)

[OK] Table locks acquired immediately: 100% (62 immediate / 62 locks)

[OK] InnoDB buffer pool / data size: 128.0M/1.2M

[OK] InnoDB log waits: 0

-------- Recommendations -----------------------------------------------------

General recommendations:

Run OPTIMIZE TABLE to defragment tables for better performance

Enable the slow query log to troubleshoot bad queries

Variables to adjust:

query_cache_limit (> 1M, or use smaller result sets)