mysql性能优化脚本mysqltuner.pl使用介绍-木庄网络博客

本文整理自网络，侵删。

MySQLTuner 下载地址：http://github.com/rackerhacker/MySQLTuner-perl

MySQLTuner 使用方法：
Downloading and using MySQLTuner is actually a very simple process:

wget mysqltuner.pl
perl mysqltuner.pl

If you'd rather not invoke perl every time, just make it executable:

chmod u+x mysqltuner.pl
./mysqltuner.pl

» Latest development version
If you want to get the bleeding edge commits, you can check out the latest code with git:

git clone git://github.com/rackerhacker/MySQLTuner-perl.git

看看我的运行结果

代码如下:

>> MySQLTuner 1.1.1 - Major Hayden
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.43-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 889M (Tables: 479)
[--] Data in MEMORY tables: 1M (Tables: 4)
[!!] Total fragmented tables: 29

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

阅读剩余部分

相关阅读 >>

主键和唯一索引的区别的是什么

mysql使用联合索引功能的示例代码分享

mysql分页时offset过大的sql优化实例分享

全网最全的一篇数据库mvcc详解，不全我负责

mysql主键索引和普通索引之间的区别是什么