mysqlreport Report
內容表格
沒有標頭
#
# Beginning report, 0 0:0:0
#
MySQL 5.0.45 uptime 19 19:10:49 Sat Oct 5 14:12:29 2013
__ Key _________________________________________________________________
Buffer used 7.08M of 8.00M %Used: 88.48
Current 2.37M %Usage: 29.60
Write hit 51.34%
Read hit 99.87%
__ Questions ___________________________________________________________
Total 40.72M 23.8/s
DMS 39.04M 22.8/s %Total: 95.88
Com_ 1.40M 0.8/s 3.44
COM_QUIT 276.61k 0.2/s 0.68
+Unknown 160 0.0/s 0.00
Slow 10 s 3 0.0/s 0.00 %DMS: 0.00 Log: OFF
DMS 39.04M 22.8/s 95.88
SELECT 37.86M 22.1/s 92.98 96.98
UPDATE 612.75k 0.4/s 1.50 1.57
INSERT 556.31k 0.3/s 1.37 1.42
DELETE 10.97k 0.0/s 0.03 0.03
REPLACE 107 0.0/s 0.00 0.00
Com_ 1.40M 0.8/s 3.44
set_option 984.90k 0.6/s 2.42
change_db 246.57k 0.1/s 0.61
show_variab 54.04k 0.0/s 0.13
__ SELECT and Sort _____________________________________________________
Scan 5.50M 3.2/s %SELECT: 14.52
Range 1.93M 1.1/s 5.09
Full join 51 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 4.69M 2.7/s
Sort range 1.74M 1.0/s
Sort mrg pass 30 0.0/s
__ Table Locks _________________________________________________________
Waited 1.36k 0.0/s %Total: 0.00
Immediate 99.51M 58.2/s
__ Tables ______________________________________________________________
Open 64 of 64 %Cache: 100.00
Opened 45.94k 0.0/s
__ Connections _________________________________________________________
Max used 60 of 100 %Max: 60.00
Total 276.62k 0.2/s
__ Created Temp ________________________________________________________
Disk table 15.32k 0.0/s
Table 8.02M 4.7/s Size: 32.0M
File 65 0.0/s
__ Threads _____________________________________________________________
Running 1 of 3
Cached 0 of 0 %Hit: 0
Created 276.62k 0.2/s
Slow 40 0.0/s
__ Aborted _____________________________________________________________
Clients 2 0.0/s
Connects 3 0.0/s
__ Bytes _______________________________________________________________
Sent 617.55M 361.0/s
Received 3.43G 2.0k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 304.00k of 8.00M %Used: 3.71
Read hit 84.42%
Pages
Free 493 %Total: 96.29
Data 19 3.71 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 77 0.0/s
From file 12 0.0/s 15.58
Ahead Rnd 1 0.0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 0 0/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 25 0.0/s
Writes 3 0.0/s
fsync 3 0.0/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 0 0/s
Read 19 0.0/s
Written 0 0/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s
#
# Interval report 1, +0 0:0:10
#
MySQL 5.0.45 uptime 19 19:10:59 Sat Oct 5 14:12:39 2013
__ Key _________________________________________________________________
Buffer used 7.08M of 8.00M %Used: 88.48
Current 8.00M %Usage: 100.00
Write hit 0.00%
Read hit 100.00%
__ Questions ___________________________________________________________
Total 29 2.9/s
DMS 18 1.8/s %Total: 62.07
Com_ 8 0.8/s 27.59
+Unknown 3 0.3/s 10.34
COM_QUIT 0 0/s 0.00
Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF
DMS 18 1.8/s 62.07
SELECT 17 1.7/s 58.62 94.44
UPDATE 1 0.1/s 3.45 5.56
REPLACE 0 0/s 0.00 0.00
DELETE 0 0/s 0.00 0.00
INSERT 0 0/s 0.00 0.00
Com_ 8 0.8/s 27.59
set_option 3 0.3/s 10.34
show_variab 2 0.2/s 6.90
show_status 1 0.1/s 3.45
__ SELECT and Sort _____________________________________________________
Scan 9 0.9/s %SELECT: 52.94
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 4 0.4/s
Sort range 0 0/s
Sort mrg pass 0 0/s
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 68 6.8/s
__ Tables ______________________________________________________________
Open 64 of 64 %Cache: 100.00
Opened 0 0/s
__ Connections _________________________________________________________
Max used 60 of 100 %Max: 60.00
Total 2 0.2/s
__ Created Temp ________________________________________________________
Disk table 0 0/s
Table 8 0.8/s Size: 32.0M
File 0 0/s
__ Threads _____________________________________________________________
Running 1 of 2
Cached 0 of 0 %Hit: 0
Created 2 0.2/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 0 0/s
__ Bytes _______________________________________________________________
Sent 37.71k 3.8k/s
Received 10.00k 1.0k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 304.00k of 8.00M %Used: 3.71
Read hit 0.00%
Pages
Free 493 %Total: 96.29
Data 19 3.71 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 0 0/s
From file 0 0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 0 0/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 0 0/s
Writes 0 0/s
fsync 0 0/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 0 0/s
Read 0 0/s
Written 0 0/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s
- 標籤 (Edit tags)
- 什麼連接到這裡
| Images 0 | ||
|---|---|---|
| No images to display in the gallery. |
您必須 登入 才能發佈評論。
Powered by MindTouch Core