请教,为什么我在运行mysqlreport的时候在开头会出现这样两行:
Use of uninitialized value in multiplication (*) at /usr/bin/mysqlreport line 829.
Use of uninitialized value in formline at /usr/bin/mysqlreport line 1227.MySQL 5.1.50-log uptime 1 0:26:30 Fri Sep 2 03:23:04 2011__ Key _________________________________________________________________
Buffer used 4.00k of 8.00M %Used: 0.05
Current 1.46M %Usage: 18.30
Write hit 0.00%
Read hit 89.74%__ Questions ___________________________________________________________
Total 62.32k 0.7/s
Com_ 55.98k 0.6/s %Total: 89.83
-Unknown 37.26k 0.4/s 59.78
COM_QUIT 17.58k 0.2/s 28.21
DMS 15.96k 0.2/s 25.61
QC Hits 10.05k 0.1/s 16.12
Slow 10 s 1.42k 0.0/s 2.28 %DMS: 8.89 Log: ON
DMS 15.96k 0.2/s 25.61
SELECT 12.18k 0.1/s 19.54 76.27
INSERT 3.79k 0.0/s 6.07 23.71
UPDATE 3 0.0/s 0.00 0.02
REPLACE 0 0/s 0.00 0.00
DELETE 0 0/s 0.00 0.00
Com_ 55.98k 0.6/s 89.83
show_status 29.52k 0.3/s 47.37
set_option 15.73k 0.2/s 25.25
change_db 7.73k 0.1/s 12.41__ SELECT and Sort _____________________________________________________
Scan 3.10k 0.0/s %SELECT: 25.49
Range 12 0.0/s 0.10
Full join 1 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 10 0.0/s
Sort range 0 0/s
Sort mrg pass 0 0/s
。
。谢谢。
Use of uninitialized value in multiplication (*) at /usr/bin/mysqlreport line 829.
Use of uninitialized value in formline at /usr/bin/mysqlreport line 1227.MySQL 5.1.50-log uptime 1 0:26:30 Fri Sep 2 03:23:04 2011__ Key _________________________________________________________________
Buffer used 4.00k of 8.00M %Used: 0.05
Current 1.46M %Usage: 18.30
Write hit 0.00%
Read hit 89.74%__ Questions ___________________________________________________________
Total 62.32k 0.7/s
Com_ 55.98k 0.6/s %Total: 89.83
-Unknown 37.26k 0.4/s 59.78
COM_QUIT 17.58k 0.2/s 28.21
DMS 15.96k 0.2/s 25.61
QC Hits 10.05k 0.1/s 16.12
Slow 10 s 1.42k 0.0/s 2.28 %DMS: 8.89 Log: ON
DMS 15.96k 0.2/s 25.61
SELECT 12.18k 0.1/s 19.54 76.27
INSERT 3.79k 0.0/s 6.07 23.71
UPDATE 3 0.0/s 0.00 0.02
REPLACE 0 0/s 0.00 0.00
DELETE 0 0/s 0.00 0.00
Com_ 55.98k 0.6/s 89.83
show_status 29.52k 0.3/s 47.37
set_option 15.73k 0.2/s 25.25
change_db 7.73k 0.1/s 12.41__ SELECT and Sort _____________________________________________________
Scan 3.10k 0.0/s %SELECT: 25.49
Range 12 0.0/s 0.10
Full join 1 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 10 0.0/s
Sort range 0 0/s
Sort mrg pass 0 0/s
。
。谢谢。
my($is, $of) = @_;
return sprintf "%.2f", ($is * 100) / ($of ||= 1);
}
1227 行
$stats{'Innodb_buffer_pool_pages_latched'}, perc($stats{'Innodb_buffer_pool_pages_latched'}, $stats{'Innodb_buffer_pool_pages_total'})
Reads @>>>>>>>> @>>>>>/s