官方站点
http://blog.mysqltuner.com/get-involved/
linux下载命令
wgethttp://mysqltuner.pl/mysqltuner.pl
简单说明（E文水平有限，有误之处，请多指教）
#./mysqltuner.pl --help
MySQLTuner 1.2.0 - MySQL High PerformanceTuning Script
Bug reports, feature requests, and downloadsat http://mysqltuner.com/
Maintained by Major Hayden ([email protected])- Licensed under GPL
Important Usage Guidelines:
To run the script with the defaultoptions, run the script without arguments
Allow MySQL server torun for at least 24-48 hours before trusting suggestions
#建议在MySQL服务器运行24-48小时，测试才有依赖性
Some routines may require root levelprivileges (script will provide warnings)
#对于越权的权限会报警
You must provide the remote server'stotal memory when connecting to other servers
#当连接其他服务器时，须提供远程服务器的总内存
Connection andAuthentication#连接、认证
--host Connect to a remote host to perform tests(default: localhost)
--socket Use a different socketfor a local connection#通常在本机测试时使用
--port Port to use for connection (default:3306)
--user Username to use for authentication
--pass Password to use for authentication
Performance and ReportingOptions#性能报告选项
--skipsize Don't enumerate tables and theirtypes/sizes (default: on)
#不列举表名以及类型和大小，默认打开，推荐打开此选项
(Recommended forservers with many tables)
--------Storage Engine Statistics -------------------------------------------
[--] Status:+Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data inMyISAM tables: 392K (Tables: 116)
[--] Data inPERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] InnoDB isenabled but isn't being used
[OK] Totalfragmented tables: 0
--checkversion Check for updates to MySQLTuner(default: don't check)
#检查更新，加了该参数效果如下
#[OK] You have the latest version ofMySQLTuner
#不加的话
#[--] Skipped version check for MySQLTunerscript
--forcemem Amount of RAM installed in megabytes
--forceswap Amount of swap memory configured inmegabytes
#设置物理内存和swap分区的大小（单位MB），这两个参数一般成对配置
#[--] Assuming 512 MB of physical memory
#[--] Assuming 1024 MB of swap space
Output Options:
#输出显示的参数试一下就清楚了
--nogood Remove OK responses
--nobad Remove negative/suggestionresponses
--noinfo Remove informational responses
--nocolor Don't print output in color
例如
./mysqltuner.pl --socket /var/lib/mysql2/mysql2.sock
……
--------Performance Metrics -------------------------------------------------
[--] Up for:23h 37m 18s (542 q [0.006 qps], 176 conn,TX: 442K, RX: 33K)
下面是该程序给的一些修改建议，大家可参考修改。有时间的话，还可以用sysbench进行测试。
--------Recommendations -----------------------------------------------------
Generalrecommendations:
Add skip-innodb to MySQL configuration todisable InnoDB
MySQL started within last 24 hours -recommendations may be inaccurate
Reduce your overall MySQL memory footprintfor system stability
Enable the slow query log to troubleshootbad queries
Set thread_cache_size to 4 as a startingvalue
Variables toadjust:
*** MySQL's maximum memory usage isdangerously high ***
*** Add RAM before increasing MySQL buffervariables ***
query_cache_size (>= 8M)
thread_cache_size (start at 4)