问一个mysqlreport的问题

Submitted by liudan182 on 周五, 2007/07/27 - 17:12

我看了你的关于mysqlreport 的文章,并下载了一个试了一下,但是我测出来的信息怎么那么少啊.
[root@localhost bak-config]# ./mysqlreport --user root --password --host 127.0.0.1
Password for database user root: *******
MySQL 5.0.22 uptime 63 6:13:56 Sat Jul 28 01:32:24 2007

__ Key _________________________________________________________________
Buffer used 30.00k of 8.00M %Used: 0.37
Current 971.99k %Usage: 11.87
Write hit 4.69%
Read hit 98.64%

__ Questions ___________________________________________________________
Total 89.76k 0.0/s
Slow 0 0/s %Total: 0.00 %DMS: 0.00
DMS 68.32k 0.0/s 76.11

__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 76.94k 0.0/s

__ Tables ______________________________________________________________
Open 58 of 64 %Cache: 90.62
Opened 18.35k 0.0/s

__ Connections _________________________________________________________
Max used 15 of 100 %Max: 15.00
Total 168 0.0/s

__ Created Temp ________________________________________________________
Disk table 2.98k 0.0/s
Table 8.40k 0.0/s
File 5 0.0/s
[root@localhost bak-config]#

还是需要什么其他的参数吗?

还有个问题就是,我现在在winxp下也装了一个mysql ,也想用这个该怎么弄?

Taxonomy upgrade extras:

yejr

周五, 2007/07/27 - 21:17 

mysqlreport --help

自己看看那详细的信息，或者耐心等我的另一篇翻译新作的发布吧。

MySQL方案、培训、支持
MySQL 用户组

liudan182

周一, 2007/07/30 - 10:52

哦,好像加上 --all 就可以了. 是这样的吗?

[root@localhost home]# ./mysqlreport --all --user root --password --host 127.0.0.1
Password for database user root:
Use of uninitialized value in numeric ne (!=) at ./mysqlreport line 759, line 1.
MySQL 3.23.54 uptime 0 0:4:52 Fri Jun 15 11:40:12 2007

__ Key _________________________________________________________________
Buffer used 0 of 8.00M %Used: 0.00
Write hit 0.00%
Read hit 0.00%

__ Questions ___________________________________________________________
Total 21 0.1/s
+Unknown 8 0.0/s %Total: 38.10
Com_ 8 0.0/s 38.10
COM_QUIT 5 0.0/s 23.81
DMS 0 0/s 0.00
Slow 0 0/s 0.00 %DMS: 0.00
DMS 0 0/s 0.00
REPLACE 0 0/s 0.00 0.00
DELETE 0 0/s 0.00 0.00
INSERT 0 0/s 0.00 0.00
SELECT 0 0/s 0.00 0.00
UPDATE 0 0/s 0.00 0.00
Com_ 8 0.0/s 38.10
show_variab 5 0.0/s 23.81
show_status 3 0.0/s 14.29

__ SELECT and Sort _____________________________________________________
Scan 0 0/s %SELECT: 0.00
Range 0 0/s 0.00
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 0 0/s
Sort range 0 0/s
Sort mrg pass 0 0/s

__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 0 0/s

__ Tables ______________________________________________________________
Open 0 of 64 %Cache: 0.00
Opened 0 0/s

__ Connections _________________________________________________________
Max used 0 of 100 %Max: 0.00
Total 7 0.0/s

__ Created Temp ________________________________________________________
Disk table 0 0/s
Table 0 0/s
File 0 0/s

__ Threads _____________________________________________________________
Running 1 of 1
Cached 0 of 0 %Hit: 14.29
Created 6 0.0/s
Slow 0 0/s

__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 0 0/s

__ Bytes _______________________________________________________________
Sent 11.16k 38.2/s
Received 253 0.9/s
[root@localhost home]#