Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MySQL 5.0.51a-log uptime 3 3:27:50 Sun Oct 23 12:04:04 2011
- __ Key _________________________________________________________________
- Buffer used 10.00k of 8.00M %Used: 0.12
- Current 953.99k %Usage: 11.65
- Write hit 0.00%
- Read hit 73.68%
- __ Questions ___________________________________________________________
- Total 6.85M 25.2/s
- QC Hits 6.32M 23.3/s %Total: 92.27
- Com_ 823.18k 3.0/s 12.01
- -Unknown 734.29k 2.7/s 10.72
- DMS 439.47k 1.6/s 6.41
- COM_QUIT 1.61k 0.0/s 0.02
- Slow (6) 1.66k 0.0/s 0.02 %DMS: 0.38 Log: ON
- DMS 439.47k 1.6/s 6.41
- SELECT 417.83k 1.5/s 6.10 95.08
- UPDATE 9.18k 0.0/s 0.13 2.09
- INSERT 7.26k 0.0/s 0.11 1.65
- DELETE 5.20k 0.0/s 0.08 1.18
- REPLACE 0 0/s 0.00 0.00
- Com_ 823.18k 3.0/s 12.01
- show_status 734.23k 2.7/s 10.72
- begin 40.88k 0.2/s 0.60
- commit 40.81k 0.2/s 0.60
- __ SELECT and Sort _____________________________________________________
- Scan 81.29k 0.3/s %SELECT: 19.46
- Range 34.51k 0.1/s 8.26
- Full join 0 0/s 0.00
- Range check 0 0/s 0.00
- Full rng join 0 0/s 0.00
- Sort scan 74.64k 0.3/s
- Sort range 159.69k 0.6/s
- Sort mrg pass 0 0/s
- __ Query Cache _________________________________________________________
- Memory usage 24.19M of 32.00M %Used: 75.60
- Block Fragmnt 18.14%
- Hits 6.32M 23.3/s
- Inserts 399.86k 1.5/s
- Insrt:Prune 21.29:1 1.4/s
- Hit:Insert 15.81:1
- __ Table Locks _________________________________________________________
- Waited 0 0/s %Total: 0.00
- Immediate 626.72k 2.3/s
- __ Tables ______________________________________________________________
- Open 293 of 800 %Cache: 36.62
- Opened 457 0.0/s
- __ Connections _________________________________________________________
- Max used 175 of 2000 %Max: 8.75
- Total 1.73k 0.0/s
- __ Created Temp ________________________________________________________
- Disk table 7.90k 0.0/s
- Table 62.31k 0.2/s Size: 96.0M
- File 5 0.0/s
- __ Threads _____________________________________________________________
- Running 1 of 60
- Cached 14 of 16 %Hit: 89.86
- Created 175 0.0/s
- Slow 2 0.0/s
- __ Aborted _____________________________________________________________
- Clients 232 0.0/s
- Connects 18 0.0/s
- __ Bytes _______________________________________________________________
- Sent 742.05M 2.7k/s
- Received 791.59M 2.9k/s
- __ InnoDB Buffer Pool __________________________________________________
- Usage 182.09M of 256.00M %Used: 71.13
- Read hit 100.00%
- Pages
- Free 4.73k %Total: 28.87
- Data 11.39k 69.51 %Drty: 0.00
- Misc 266 1.62
- Latched 0 0.00
- Reads 290.53M 1.1k/s
- From file 2.86k 0.0/s 0.00
- Ahead Rnd 3 0.0/s
- Ahead Sql 63 0.0/s
- Writes 2.83M 10.4/s
- Flushes 65.30k 0.2/s
- Wait Free 0 0/s
- __ InnoDB Lock _________________________________________________________
- Waits 70 0.0/s
- Current 0
- Time acquiring
- Total 20367 ms
- Average 290 ms
- Max 2017 ms
- __ InnoDB Data, Pages, Rows ____________________________________________
- Data
- Reads 3.12k 0.0/s
- Writes 59.85k 0.2/s
- fsync 36.88k 0.1/s
- Pending
- Reads 0
- Writes 0
- fsync 0
- Pages
- Created 5.41k 0.0/s
- Read 5.98k 0.0/s
- Written 65.30k 0.2/s
- Rows
- Deleted 5.20k 0.0/s
- Inserted 553.82k 2.0/s
- Read 1.31G 4.8k/s
- Updated 9.18k 0.0/s
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
