Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MySQL 5.0.32-Debian_7et uptime 0 6:15:49 Fri Apr 25 10:50:45 2008
- __ Key _________________________________________________________________
- Buffer used 60.00k of 16.00M %Used: 0.37
- Current 1.86M %Usage: 11.62
- Write hit 99.93%
- Read hit 99.02%
- __ Questions ___________________________________________________________
- Total 1.01M 44.8/s
- DMS 589.69k 26.2/s %Total: 58.34
- QC Hits 363.27k 16.1/s 35.94
- Com_ 300.05k 13.3/s 29.68
- -Unknown 242.79k 10.8/s 24.02
- COM_QUIT 648 0.0/s 0.06
- Slow 10 s 5 0.0/s 0.00 %DMS: 0.00 Log: ON
- DMS 589.69k 26.2/s 58.34
- SELECT 546.93k 24.3/s 54.10 92.75
- INSERT 20.89k 0.9/s 2.07 3.54
- UPDATE 18.30k 0.8/s 1.81 3.10
- DELETE 3.57k 0.2/s 0.35 0.61
- REPLACE 0 0/s 0.00 0.00
- Com_ 300.05k 13.3/s 29.68
- show_status 242.97k 10.8/s 24.04
- show_fields 39.42k 1.7/s 3.90
- begin 7.76k 0.3/s 0.77
- __ SELECT and Sort _____________________________________________________
- Scan 52.54k 2.3/s %SELECT: 9.61
- Range 102.29k 4.5/s 18.70
- Full join 31 0.0/s 0.01
- Range check 0 0/s 0.00
- Full rng join 369 0.0/s 0.07
- Sort scan 147.86k 6.6/s
- Sort range 96.77k 4.3/s
- Sort mrg pass 349 0.0/s
- __ Query Cache _________________________________________________________
- Memory usage 9.22M of 16.00M %Used: 57.63
- Block Fragmnt 20.12%
- Hits 363.27k 16.1/s
- Inserts 540.28k 24.0/s
- Insrt:Prune 3.92:1 17.8/s
- Hit:Insert 0.67:1
- __ Table Locks _________________________________________________________
- Waited 0 0/s %Total: 0.00
- Immediate 1.01M 45.0/s
- __ Tables ______________________________________________________________
- Open 318 of 1024 %Cache: 31.05
- Opened 436 0.0/s
- __ Connections _________________________________________________________
- Max used 60 of 100 %Max: 60.00
- Total 655 0.0/s
- __ Created Temp ________________________________________________________
- Disk table 122.32k 5.4/s
- Table 193.63k 8.6/s Size: 32.0M
- File 704 0.0/s
- __ Threads _____________________________________________________________
- Running 2 of 57
- Cached 3 of 16 %Hit: 90.84
- Created 60 0.0/s
- Slow 0 0/s
- __ Aborted _____________________________________________________________
- Clients 10 0.0/s
- Connects 3 0.0/s
- __ Bytes _______________________________________________________________
- Sent 107.92M 4.8k/s
- Received 466.98M 20.7k/s
- __ InnoDB Buffer Pool __________________________________________________
- Usage 1.46G of 1.46G %Used: 100.00
- Read hit 99.94%
- Pages
- Free 0 %Total: 0.00
- Data 92.86k 96.72 %Drty: 0.52
- Misc 3144 3.27
- Latched 1 0.00
- Reads 2.34G 103.8k/s
- From file 1.38M 61.4/s 0.06
- Ahead Rnd 74468 3.3/s
- Ahead Sql 39771 1.8/s
- Writes 400.74k 17.8/s
- Flushes 35.07k 1.6/s
- Wait Free 0 0/s
- __ InnoDB Lock _________________________________________________________
- Waits 1 0.0/s
- Current 0
- Time acquiring
- Total 13 ms
- Average 13 ms
- Max 13 ms
- __ InnoDB Data, Pages, Rows ____________________________________________
- Data
- Reads 2.04M 90.4/s
- Writes 103.12k 4.6/s
- fsync 21.94k 1.0/s
- Pending
- Reads 0
- Writes 0
- fsync 0
- Pages
- Created 246 0.0/s
- Read 5.04M 223.5/s
- Written 35.07k 1.6/s
- Rows
- Deleted 7.86k 0.3/s
- Inserted 14.90k 0.7/s
- Read 3.32G 147.4k/s
- Updated 23.57k 1.0/s
Add Comment
Please, Sign In to add comment