rendered paste bodyMySQL 5.0.24a-Debian_3- uptime 0 13:44:0 Mon Oct 2 11:44:26 2006
__ Key _________________________________________________________________
Buffer used 3.54M of 128.00M %Used: 2.76
Current 17.92M %Usage: 14.00
Write ratio 0.94
Read ratio 0.01
__ Questions ___________________________________________________________
Total 525.41k 10.63/s
DMS 298.96k 6.05/s %Total: 56.90
QC Hits 221.66k 4.48/s 42.19
Com_ 2.69k 0.05/s 0.51
COM_QUIT 2.13k 0.04/s 0.41
-Unknown 16 0.00/s 0.00
Slow 0 0.00/s 0.00 %DMS: 0.00
DMS 298.96k 6.05/s 56.90
SELECT 170.19k 3.44/s 32.39 56.93
INSERT 97.84k 1.98/s 18.62 32.73
DELETE 28.25k 0.57/s 5.38 9.45
UPDATE 2.68k 0.05/s 0.51 0.90
REPLACE 0 0.00/s 0.00 0.00
Com_ 2.69k 0.05/s 0.51
change_db 2.11k 0.04/s 0.40
set_option 453 0.01/s 0.09
drop_index 27 0.00/s 0.01
truncate 27 0.00/s 0.01
create_inde 27 0.00/s 0.01
commit 18 0.00/s 0.00
begin 18 0.00/s 0.00
show_status 1 0.00/s 0.00
show_variab 1 0.00/s 0.00
__ SELECT and Sort _____________________________________________________
Scan 7.16k 0.14/s %SELECT: 4.21
Range 324 0.01/s 0.19
Full join 3 0.00/s 0.00
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 1.72k 0.03/s
Sort range 769 0.02/s
Sort mrg pass 0 0.00/s
__ Query Cache _________________________________________________________
Memory usage 36.74M of 256.00M %Used: 14.35
Block Fragmnt 11.03%
Hits 221.66k 4.48/s
Inserts 167.62k 3.39/s
Prunes 1 0.00/s
Insrt:Prune 167.62k:1 3.39/s
Hit:Insert 1.32:1
__ Table Locks _________________________________________________________
Waited 2 0.00/s %Total: 0.00
Immediate 302.84k 6.13/s
__ Tables ______________________________________________________________
Open 111 of 512 %Cache: 21.68
Opened 330 0.01/s
__ Connections _________________________________________________________
Max used 7 of 500 %Max: 1.40
Total 2.15k 0.04/s
__ Created Temp ________________________________________________________
Disk table 41 0.00/s
Table 774 0.02/s
File 4 0.00/s
__ Threads _____________________________________________________________
Running 1 of 4
Cached 3 of 6 %Hit: 99.67
Created 7 0.00/s
Slow 0 0.00/s
__ Aborted _____________________________________________________________
Clients 32 0.00/s
Connects 13 0.00/s
__ Bytes _______________________________________________________________
Sent 385.54M 7.80k/s
Received 82.58M 1.67k/s