Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MySQL 5.5.42-cll uptime 0 20:49:19 Mon Sep 28 10:06:26 2015
- __ Key _________________________________________________________________
- Buffer used 0 of 0 %Used: 0.00
- Current 0 %Usage: 0.00
- Write hit 0.00%
- Read hit 0.00%
- __ Questions ___________________________________________________________
- Total 6.03M 80.4/s
- QC Hits 2.77M 37.0/s %Total: 46.03
- DMS 1.73M 23.0/s 28.63
- Com_ 1.45M 19.3/s 24.02
- COM_QUIT 288.65k 3.9/s 4.79
- -Unknown 209.56k 2.8/s 3.48
- Slow 1 s 10.48k 0.1/s 0.17 %DMS: 0.61 Log: ON
- DMS 1.73M 23.0/s 28.63
- SELECT 1.30M 17.4/s 21.58 75.35
- UPDATE 285.41k 3.8/s 4.73 16.54
- DELETE 74.06k 1.0/s 1.23 4.29
- INSERT 60.54k 0.8/s 1.00 3.51
- REPLACE 5.40k 0.1/s 0.09 0.31
- Com_ 1.45M 19.3/s 24.02
- set_option 784.31k 10.5/s 13.01
- change_db 299.26k 4.0/s 4.96
- admin_comma 206.35k 2.8/s 3.42
- __ SELECT and Sort _____________________________________________________
- Scan 268.43k 3.6/s %SELECT: 20.64
- Range 275.54k 3.7/s 21.19
- Full join 9.47k 0.1/s 0.73
- Range check 29.06k 0.4/s 2.23
- Full rng join 6 0.0/s 0.00
- Sort scan 172.26k 2.3/s
- Sort range 102.19k 1.4/s
- Sort mrg pass 4.89k 0.1/s
- __ Query Cache _________________________________________________________
- Memory usage 411.31M of 768.00M %Used: 53.56
- Block Fragmnt 4.50%
- Hits 2.77M 37.0/s
- Inserts 1.08M 14.3/s
- Insrt:Prune 5.08:1 11.5/s
- Hit:Insert 2.58:1
- __ Table Locks _________________________________________________________
- Waited 2.80k 0.0/s %Total: 0.11
- Immediate 2.46M 32.8/s
- __ Tables ______________________________________________________________
- Open 728 of 728 %Cache: 100.00
- Opened 3.45M 46.0/s
- __ Connections _________________________________________________________
- Max used 64 of 200 %Max: 32.00
- Total 288.73k 3.9/s
- __ Created Temp ________________________________________________________
- Disk table 173.57k 2.3/s
- Table 371.59k 5.0/s Size: 1.0G
- File 9.16k 0.1/s
- __ Threads _____________________________________________________________
- Running 1 of 6
- Cached 9 of 12 %Hit: 99.69
- Created 883 0.0/s
- Slow 0 0/s
- __ Aborted _____________________________________________________________
- Clients 152 0.0/s
- Connects 113 0.0/s
- __ Bytes _______________________________________________________________
- Sent 294.20G 3.9M/s
- Received 1.07G 14.2k/s
- __ InnoDB Buffer Pool __________________________________________________
- Usage 759.97M of 759.98M %Used: 100.00
- Read hit 99.82%
- Pages
- Free 1 %Total: 0.00
- Data 48.39k 99.48 %Drty: 0.00
- Misc 250 0.51
- Latched 0.00
- Reads 39.83M 531.4/s
- From file 72.79k 1.0/s 0.18
- Ahead Rnd 0 0/s
- Ahead Sql 0/s
- Writes 147.09k 2.0/s
- Flushes 35.69k 0.5/s
- Wait Free 0 0/s
- __ InnoDB Lock _________________________________________________________
- Waits 5 0.0/s
- Current 0
- Time acquiring
- Total 4536 ms
- Average 907 ms
- Max 4535 ms
- __ InnoDB Data, Pages, Rows ____________________________________________
- Data
- Reads 78.04k 1.0/s
- Writes 53.82k 0.7/s
- fsync 24.84k 0.3/s
- Pending
- Reads 0
- Writes 0
- fsync 0
- Pages
- Created 1.13k 0.0/s
- Read 73.40k 1.0/s
- Written 35.69k 0.5/s
- Rows
- Deleted 2.64k 0.0/s
- Inserted 9.21k 0.1/s
- Read 8.40M 112.0/s
- Updated 4.83k 0.1/s
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
