Key _________________________________________________________________
Buffer used 12.54M of 155.00M %Used: 8.09
Current 20.01M %Usage: 12.91
Write hit 100.00%
Read hit 100.00%__ Questions ___________________________________________________________
Total 73.58M 142.6/s
DMS 65.51M 127.0/s %Total: 89.04
Com_ 7.22M 14.0/s 9.82
QC Hits 853.65k 1.7/s 1.16
-Unknown 20.96k 0.0/s 0.03
COM_QUIT 8.87k 0.0/s 0.01
Slow 5 s 224 0.0/s 0.00 %DMS: 0.00 Log: ON
DMS 65.51M 127.0/s 89.04
SELECT 57.59M 111.6/s 78.27 87.91
UPDATE 4.41M 8.6/s 6.00 6.74
INSERT 3.40M 6.6/s 4.63 5.20
DELETE 102.66k 0.2/s 0.14 0.16
REPLACE 0 0/s 0.00 0.00
Com_ 7.22M 14.0/s 9.82
show_warnin 6.96M 13.5/s 9.46
show_fields 187.49k 0.4/s 0.25
set_option 26.98k 0.1/s 0.04__ SELECT and Sort _____________________________________________________
Scan 300.81k 0.6/s %SELECT: 0.52
Range 275.20k 0.5/s 0.48
Full join 13 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 18.99k 0.0/s
Sort range 61 0.0/s
Sort mrg pass 13.61k 0.0/s__ Query Cache _________________________________________________________
Memory usage 6.90M of 99.00M %Used: 6.97
Block Fragmnt 4.64%
Hits 853.65k 1.7/s
Inserts 13.34M 25.9/s
Insrt:Prune 13.34M:1 25.9/s
Hit:Insert 0.06:1__ Table Locks _________________________________________________________
Waited 297 0.0/s %Total: 0.00
Immediate 21.31M 41.3/s__ Tables ______________________________________________________________
Open 43 of 320 %Cache: 13.44
Opened 24.46k 0.0/s__ Connections _________________________________________________________
Max used 28 of 1500 %Max: 1.87
Total 10.15k 0.0/s__ Created Temp ________________________________________________________
Disk table 190.99k 0.4/s
Table 214.95k 0.4/s Size: 103.0M
File 26.51k 0.1/s__ Threads _____________________________________________________________
Running 3 of 21
Cached 4 of 8 %Hit: 99.14
Created 87 0.0/s
Slow 0 0/s__ Aborted _____________________________________________________________
Clients 2.57k 0.0/s
Connects 6 0.0/s__ Bytes _______________________________________________________________
Sent 91.09G 176.6k/s
Received 3.60G 7.0k/s__ InnoDB Buffer Pool __________________________________________________
Usage 1.00G of 1.00G %Used: 100.00
Read hit 99.71%
Pages
Free 1 %Total: 0.00
Data 62.00k 94.60 %Drty: 68.93
Misc 3539 5.40
Latched 0.00
Reads 1.36G 2.6k/s
From file 3.89M 7.5/s 0.29
Ahead Rnd 0/s
Ahead Sql 0/s
Writes 114.50M 221.9/s
Flushes 7.59M 14.7/s
Wait Free 0 0/s__ InnoDB Lock _________________________________________________________
Waits 169 0.0/s
Current 0
Time acquiring
Total 22000953 ms
Average 130183 ms
Max 2592093 ms__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 8.83M 17.1/s
Writes 11.93M 23.1/s
fsync 373.36k 0.7/s
Pending
Reads 0
Writes 0
fsync 1Pages
Created 223.55k 0.4/s
Read 8.83M 17.1/s
Written 3.80M 7.4/sRows
Deleted 3.20M 6.2/s
Inserted 13.42M 26.0/s
Read 849.74M 1.6k/s
Updated 4.57M 8.9/s以上是小弟优化mysql的报告。希望大家给出建议。那个地方不够合理。CPU 650 I5,4g内存,windows Server 2003
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货