MySQL 5.1.26-rc-5.1.26r uptime 0 1:3:7 Wed Nov 4 08:45:12 2009 2 3 __ Key _________________________________________________________________ 4 Buffer used 7.40M of 24.00M %Used: 30.84 5 Current 10.68M %Usage: 44.51 6 Write hit 99.11% 7 Read hit 99.87% 8 9 __ Questions ___________________________________________________________ 10 Total 6.35k 1.7/s 11 DMS 4.18k 1.1/s %Total: 65.87 12 QC Hits 1.15k 0.3/s 18.06 13 COM_QUIT 986 0.3/s 15.54 14 Com_ 945 0.2/s 14.89 15 -Unknown 911 0.2/s 14.36 16 Slow 769 0.2/s 12.12 %DMS: 18.40 17 DMS 4.18k 1.1/s 65.87 18 SELECT 3.97k 1.0/s 62.59 95.02 19 INSERT 115 0.0/s 1.81 2.75 20 DELETE 51 0.0/s 0.80 1.22 21 UPDATE 42 0.0/s 0.66 1.00 22 REPLACE 0 0/s 0.00 0.00 23 Com_ 945 0.2/s 14.89 24 check 582 0.2/s 9.17 25 change_db 109 0.0/s 1.72 26 set_option 98 0.0/s 1.54 27 28 __ SELECT and Sort _____________________________________________________ 29 Scan 913 0.2/s %SELECT: 22.99 30 Range 15 0.0/s 0.38 31 Full join 0 0/s 0.00 32 Range check 0 0/s 0.00 33 Full rng join 0 0/s 0.00 34 Sort scan 76 0.0/s 35 Sort range 33 0.0/s 36 Sort mrg pass 2 0.0/s 37 38 __ Query Cache _________________________________________________________ 39 Memory usage 1.97M of 12.00M %Used: 16.42 40 Block Fragmnt 2.25% 41 Hits 1.15k 0.3/s 42 Inserts 622 0.2/s 43 Insrt:Prune 622:1 0.2/s 44 Hit:Insert 1.84:1 45 46 __ Table Locks _________________________________________________________ 47 Waited 151 0.0/s %Total: 6.15 48 Immediate 2.30k 0.6/s 49 50 __ Tables ______________________________________________________________ 51 Open 318 of 1024 %Cache: 31.05 52 Opened 399 0.1/s 53 54 __ Connections _________________________________________________________ 55 Max used 19 of 60 %Max: 31.67 56 Total 1.37k 0.4/s 57 58 __ Created Temp ________________________________________________________ 59 Disk table 92 0.0/s 60 Table 146 0.0/s 61 File 9 0.0/s 62 63 __ Threads _____________________________________________________________ 64 Running 16 of 16 65 Cached 1 of 4 %Hit: 96.71 66 Created 45 0.0/s 67 Slow 0 0/s 68 69 __ Aborted _____________________________________________________________ 70 Clients 761 0.2/s 71 Connects 471 0.1/s 72 73 __ Bytes _______________________________________________________________ 74 Sent 122.72G 32.4M/s 75 Received 914.08k 241.4/s
Pasted:
Nov 4, 2009, 6:46:42 pm
Views:
45
