rendered paste bodyThis MySQL server has been running for 1 days, 22 hours, 48 minutes and 24 seconds. It started up on Oct 08, 2005 at 12:05 AM.
Server traffic: These tables show the network traffic statistics of this MySQL server since its startup.
Traffic ø per hour
Received 557,328 Bytes 11,907 Bytes
Sent 287,680 KB 6,146 KB
Total 288,224 KB 6,158 KB
Connections ø per hour %
Failed attempts 0 0.00 0.00 %
Aborted 12 0.26 0.40 %
Total 2,992 63.92 100.00 %
Query statistics: Since its startup, 1,578,341 queries have been sent to the server. Total ø per hour ø per minute ø per second
1,578,341 33,720.43 562.01 9.37
Query type ø per hour %
admin commands 0 0.00 0.00 %
alter db 0 0.00 0.00 %
alter table 0 0.00 0.00 %
analyze 0 0.00 0.00 %
backup table 0 0.00 0.00 %
begin 0 0.00 0.00 %
change db 2 0.04 0.00 %
change master 0 0.00 0.00 %
check 0 0.00 0.00 %
checksum 0 0.00 0.00 %
commit 0 0.00 0.00 %
create db 0 0.00 0.00 %
create function 0 0.00 0.00 %
create index 0 0.00 0.00 %
create table 0 0.00 0.00 %
dealloc sql 0 0.00 0.00 %
delete 0 0.00 0.00 %
delete multi 0 0.00 0.00 %
do 0 0.00 0.00 %
drop db 0 0.00 0.00 %
drop function 0 0.00 0.00 %
drop index 0 0.00 0.00 %
drop table 0 0.00 0.00 %
drop user 0 0.00 0.00 %
execute sql 0 0.00 0.00 %
flush 0 0.00 0.00 %
grant 0 0.00 0.00 %
ha close 0 0.00 0.00 %
ha open 0 0.00 0.00 %
ha read 0 0.00 0.00 %
help 0 0.00 0.00 %
insert 2,882 61.57 0.18 %
insert select 0 0.00 0.00 %
kill 0 0.00 0.00 %
load 0 0.00 0.00 %
load master data 0 0.00 0.00 %
load master table 0 0.00 0.00 %
lock tables 0 0.00 0.00 %
optimize 0 0.00 0.00 %
preload keys 0 0.00 0.00 %
prepare sql 0 0.00 0.00 %
purge 0 0.00 0.00 %
purge before date 0 0.00 0.00 %
rename table 0 0.00 0.00 %
repair 0 0.00 0.00 %
replace 0 0.00 0.00 %
Query type ø per hour %
replace select 0 0.00 0.00 %
reset 0 0.00 0.00 %
restore table 0 0.00 0.00 %
revoke 0 0.00 0.00 %
revoke all 0 0.00 0.00 %
rollback 0 0.00 0.00 %
savepoint 0 0.00 0.00 %
select 155 3.31 0.01 %
set option 25 0.53 0.00 %
show binlog events 0 0.00 0.00 %
show binlogs 3 0.06 0.00 %
show charsets 6 0.13 0.00 %
show collations 6 0.13 0.00 %
show column types 0 0.00 0.00 %
show create db 0 0.00 0.00 %
show create table 0 0.00 0.00 %
show databases 3 0.06 0.00 %
show errors 0 0.00 0.00 %
show fields 0 0.00 0.00 %
show grants 1 0.02 0.00 %
show innodb status 0 0.00 0.00 %
show keys 0 0.00 0.00 %
show logs 0 0.00 0.00 %
show master status 0 0.00 0.00 %
show new master 0 0.00 0.00 %
show open tables 0 0.00 0.00 %
show privileges 0 0.00 0.00 %
show processlist 10 0.21 0.00 %
show slave hosts 0 0.00 0.00 %
show slave status 0 0.00 0.00 %
show status 11 0.24 0.00 %
show storage engines 0 0.00 0.00 %
show tables 12 0.26 0.00 %
show variables 13 0.28 0.00 %
show warnings 0 0.00 0.00 %
slave start 0 0.00 0.00 %
slave stop 0 0.00 0.00 %
stmt prepare 0 0.00 0.00 %
stmt execute 0 0.00 0.00 %
stmt send long data 0 0.00 0.00 %
stmt reset 0 0.00 0.00 %
stmt close 0 0.00 0.00 %
truncate 0 0.00 0.00 %
unlock tables 0 0.00 0.00 %
update 161 3.44 0.01 %
update multi 0 0.00 0.00 %
More status variables
Variable Value
Binlog cache disk use 0
Binlog cache use 0
Created tmp disk tables 0
Created tmp files 0
Created tmp tables 0
Delayed errors 0
Delayed insert threads 0
Delayed writes 0
Flush commands 1
Handler commit 0
Handler delete 0
Handler discover 0
Handler read first 0
Handler read key 257
Handler read next 10495019
Handler read prev 0
Handler read rnd 0
Handler read rnd next 37629920
Handler rollback 0
Handler update 157
Handler write 2882
Variable Value
Key blocks not flushed 0
Key blocks unused 49705
Key blocks used 66275
Key read requests 3570374
Key reads 31
Key write requests 876
Key writes 869
Max used connections 0
Not flushed delayed rows 0
Open files 12
Open streams 0
Open tables 6
Opened tables 0
Qcache free blocks 4
Qcache free memory 33196392
Qcache hits 217
Qcache inserts 97
Qcache lowmem prunes 0
Qcache not cached 58
Qcache queries in cache 5
Qcache total blocks 15
Variable Value
Rpl status NULL
Select full join 0
Select full range join 0
Select range 0
Select range check 0
Select scan 49
Slave open temp tables 0
Slave running OFF
Slave retried transactions 0
Slow launch threads 0
Slow queries 13
Sort merge passes 0
Sort range 0
Sort rows 0
Sort scan 0
Table locks immediate 3143
Table locks waited 48
Threads cached 1
Threads connected 5
Threads created 6
Threads running 3