MySQL数据库的分析报告工具
Thursday, 8. February 2007, 04:03:33
在一个叫 Hack MySQL 的网站上，发现了一个 mysqlreport的Perl脚本，在MySQL服务器上运行该脚本，就能给你制作一份漂亮的MySQL运行情况报告，对于MySQL的性能分析以及调优很有帮助。
运行该脚本之前，可能需要修改的地方：
# Default values if nothing else
$mycnf{'host'} ||= 'localhost';
$mycnf{'port'} ||= 3306;
$mycnf{'socket'} ||= '/var/run/mysqld/mysqld.sock'; # Debian default
$mycnf{'user'} ||= $ENV{'USER'};
我只修改了其中关于socket文件的一句：
$mycnf{'socket'} ||= '/tmp/mysql.sock'; # Debian default
执行结果就出来了:
MySQL 4.1.16-log uptime 12 13:20:50 Thu Feb 8 11:10:26 2007
__ Key _________________________________________________________________
Buffer used 372.00k of 16.00M %Used: 2.27
Current 1.86M %Usage: 11.62
Write ratio 0.000
Read ratio 0.012
__ Questions ___________________________________________________________
Total 2.40M 2.2/s
Slow 0 0/s %Total: 0.00 %DMS: 0.00
DMS 540 0.0/s 0.02
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 540 0.0/s
__ Tables ______________________________________________________________
Open 7 of 64 %Cache: 10.94
Opened 7 0.0/s
__ Connections _________________________________________________________
Max used 3 of 100 %Max: 3.00
Total 18.08k 0.0/s
__ Created Temp ________________________________________________________
Disk table 0 0/s
Table 0 0/s
File 0 0/s
运行该脚本之前，可能需要修改的地方：
# Default values if nothing else
$mycnf{'host'} ||= 'localhost';
$mycnf{'port'} ||= 3306;
$mycnf{'socket'} ||= '/var/run/mysqld/mysqld.sock'; # Debian default
$mycnf{'user'} ||= $ENV{'USER'};
我只修改了其中关于socket文件的一句：
$mycnf{'socket'} ||= '/tmp/mysql.sock'; # Debian default
执行结果就出来了:
MySQL 4.1.16-log uptime 12 13:20:50 Thu Feb 8 11:10:26 2007
__ Key _________________________________________________________________
Buffer used 372.00k of 16.00M %Used: 2.27
Current 1.86M %Usage: 11.62
Write ratio 0.000
Read ratio 0.012
__ Questions ___________________________________________________________
Total 2.40M 2.2/s
Slow 0 0/s %Total: 0.00 %DMS: 0.00
DMS 540 0.0/s 0.02
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 540 0.0/s
__ Tables ______________________________________________________________
Open 7 of 64 %Cache: 10.94
Opened 7 0.0/s
__ Connections _________________________________________________________
Max used 3 of 100 %Max: 3.00
Total 18.08k 0.0/s
__ Created Temp ________________________________________________________
Disk table 0 0/s
Table 0 0/s
File 0 0/s
WIDGETIZE