我用最新版的phpmyadmin V2.8.2,可以看到下面的统计,排版有的乱。不知道是不是你想要的?
查询统计:自从启动后,服务器共收到了 242 次查询。
统计 ø 每小时 ø 每分钟 ø 每秒
242 418.44 6.97 0.12 查询方式 ø 每小时 %
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 32 55.33 14.22%
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 1 1.73 0.44%
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 1 1.73 0.44%
drop user 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 0 0.00 0.00%
insert select 0 0.00 0.00%
kill 0 0.00 0.00%
load 1 1.73 0.44%
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%
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%
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 42 72.62 18.67%
set option 60 103.75 26.67%
show binlog events 0 0.00 0.00%
show binlogs 7 12.10 3.11%
show charsets 15 25.94 6.67%
show collations 15 25.94 6.67%
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 0 0.00 0.00%
show errors 0 0.00 0.00%
show fields 1 1.73 0.44%
show grants 4 6.92 1.78%
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 ndb 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 0 0.00 0.00%
show slave hosts 0 0.00 0.00%
show slave status 0 0.00 0.00%
show status 3 5.19 1.33%
show storage engines 0 0.00 0.00%
show tables 13 22.48 5.78%
show triggers 0 0.00 0.00%
show variables 32 55.33 14.22%
show warnings 1 1.73 0.44%
slave start 0 0.00 0.00%
slave stop 0 0.00 0.00%
stmt close 0 0.00 0.00%
stmt execute 0 0.00 0.00%
stmt fetch 0 0.00 0.00%
stmt prepare 0 0.00 0.00%
stmt reset 0 0.00 0.00%
stmt send long data 0 0.00 0.00%
truncate 0 0.00 0.00%
unlock tables 0 0.00 0.00%
update 0 0.00 0.00%
update multi 0 0.00 0.00%
xa commit 0 0.00 0.00%
xa end 0 0.00 0.00%
xa prepare 0 0.00 0.00%
xa recover 0 0.00 0.00%
xa rollback 0 0.00 0.00%
xa start 0 0.00 0.00%
从上面可以看出,select的操作比较多.
查询统计:自从启动后,服务器共收到了 242 次查询。
统计 ø 每小时 ø 每分钟 ø 每秒
242 418.44 6.97 0.12 查询方式 ø 每小时 %
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 32 55.33 14.22%
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 1 1.73 0.44%
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 1 1.73 0.44%
drop user 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 0 0.00 0.00%
insert select 0 0.00 0.00%
kill 0 0.00 0.00%
load 1 1.73 0.44%
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%
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%
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 42 72.62 18.67%
set option 60 103.75 26.67%
show binlog events 0 0.00 0.00%
show binlogs 7 12.10 3.11%
show charsets 15 25.94 6.67%
show collations 15 25.94 6.67%
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 0 0.00 0.00%
show errors 0 0.00 0.00%
show fields 1 1.73 0.44%
show grants 4 6.92 1.78%
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 ndb 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 0 0.00 0.00%
show slave hosts 0 0.00 0.00%
show slave status 0 0.00 0.00%
show status 3 5.19 1.33%
show storage engines 0 0.00 0.00%
show tables 13 22.48 5.78%
show triggers 0 0.00 0.00%
show variables 32 55.33 14.22%
show warnings 1 1.73 0.44%
slave start 0 0.00 0.00%
slave stop 0 0.00 0.00%
stmt close 0 0.00 0.00%
stmt execute 0 0.00 0.00%
stmt fetch 0 0.00 0.00%
stmt prepare 0 0.00 0.00%
stmt reset 0 0.00 0.00%
stmt send long data 0 0.00 0.00%
truncate 0 0.00 0.00%
unlock tables 0 0.00 0.00%
update 0 0.00 0.00%
update multi 0 0.00 0.00%
xa commit 0 0.00 0.00%
xa end 0 0.00 0.00%
xa prepare 0 0.00 0.00%
xa recover 0 0.00 0.00%
xa rollback 0 0.00 0.00%
xa start 0 0.00 0.00%
从上面可以看出,select的操作比较多.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货