mysql 分析报告_MySQLReport分析报告一

OS：windows2003 配置：8G内存，4核处理器

__ Key _________________________________________________________________

Buffer used 27.67M of 155.00M %Used: 17.85

Current 20.01M %Usage: 12.91

Write hit 100.00%

Read hit 100.00%

__ Questions ___________________________________________________________

Total 8.62M 116.0/s

DMS 8.14M 109.6/s %Total: 94.44

QC Hits 419.13k 5.6/s 4.86

Com_ 60.99k 0.8/s 0.71

-Unknown 2.27k 0.0/s 0.03

COM_QUIT 1.30k 0.0/s 0.02

Slow 5 s 195 0.0/s 0.00 %DMS: 0.00 Log: ON

DMS 8.14M 109.6/s 94.44

SELECT 7.13M 95.9/s 82.69 87.55

UPDATE 549.25k 7.4/s 6.37 6.75

INSERT 437.39k 5.9/s 5.07 5.37

DELETE 26.73k 0.4/s 0.31 0.33

REPLACE 0 0/s 0.00 0.00

Com_ 60.99k 0.8/s 0.71

show_fields 46.88k 0.6/s 0.54

show_create 6.11k 0.1/s 0.07

set_option 3.54k 0.0/s 0.04

__ SELECT and Sort _____________________________________________________

Scan 55.08k 0.7/s %SELECT: 0.77

Range 18.54k 0.2/s 0.26

Full join 1 0.0/s 0.00

Range check 0 0/s 0.00

Full rng join 0 0/s 0.00

Sort scan 1.02k 0.0/s

Sort range 23 0.0/s

Sort mrg pass 443 0.0/s

__ Query Cache _________________________________________________________

Memory usage 1.71M of 99.00M %Used: 1.73

Block Fragmnt 18.22%

Hits 419.13k 5.6/s

Inserts 1.42M 19.2/s

Insrt:Prune 1.42M:1 19.2/s

Hit:Insert 0.29:1

__ Table Locks _________________________________________________________

Waited 44 0.0/s %Total: 0.00

Immediate 2.44M 32.9/s

__ Tables ______________________________________________________________

Open 38 of 320 %Cache: 11.88

Opened 6.69k 0.1/s

__ Connections _________________________________________________________

Max used 29 of 1500 %Max: 1.93

Total 1.46k 0.0/s

__ Created Temp ________________________________________________________

Disk table 48.19k 0.6/s

Table 53.23k 0.7/s Size: 103.0M

File 473 0.0/s

__ Threads _____________________________________________________________

Running 2 of 25

Cached 0 of 8 %Hit: 97.06

Created 43 0.0/s

Slow 0 0/s

__ Aborted _____________________________________________________________

Clients 321 0.0/s

Connects 5 0.0/s

__ Bytes _______________________________________________________________

Sent 12.05G 162.2k/s

Received 450.03M 6.1k/s

__ InnoDB Buffer Pool __________________________________________________

Usage 1.00G of 1.00G %Used: 100.00

Read hit 99.92%

Pages

Free 1 %Total: 0.00

Data 63.95k 97.58 %Drty: 22.81

Misc 1583 2.42

Latched 0.00

Reads 835.19M 11.2k/s

From file 657.78k 8.9/s 0.08

Ahead Rnd 0/s

Ahead Sql 0/s

Writes 21.16M 284.8/s

Flushes 1.10M 14.8/s

Wait Free 0 0/s

__ InnoDB Lock _________________________________________________________

Waits 9 0.0/s

Current 0

Time acquiring

Total 2346968 ms

Average 260774 ms

Max 1005125 ms

__ InnoDB Data, Pages, Rows ____________________________________________

Data

Reads 1.32M 17.8/s

Writes 1.58M 21.2/s

fsync 49.89k 0.7/s

Pending

Reads 0

Writes 0

fsync 0

Pages

Created 33.66k 0.5/s

Read 1.32M 17.8/s

Written 550.68k 7.4/s

Rows

Deleted 437.44k 5.9/s

Inserted 3.01M 40.5/s

Read 864.12M 11.6k/s

Updated 829.91k 11.2/s