Query type |
ø per hour |
% |
admin commands |
8 |
0.15 |
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 |
9,507 |
174.97 |
0.17 % |
change master |
0 |
0.00 |
0.00 % |
check |
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 % |
delete |
93,662 |
1,723.81 |
1.71 % |
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 % |
flush |
0 |
0.00 |
0.00 % |
grant |
0 |
0.00 |
0.00 % |
insert |
3,246,117 |
59,743.57 |
59.31 % |
insert select |
15 |
0.28 |
0.00 % |
kill |
0 |
0.00 |
0.00 % |
load |
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 % |
purge |
0 |
0.00 |
0.00 % |
rename table |
0 |
0.00 |
0.00 % | |
Query type |
ø per hour |
% |
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 % |
rollback |
0 |
0.00 |
0.00 % |
select |
2,020,195 |
37,180.93 |
36.91 % |
set option |
213 |
3.92 |
0.00 % |
show binlogs |
0 |
0.00 |
0.00 % |
show create |
0 |
0.00 |
0.00 % |
show databases |
20 |
0.37 |
0.00 % |
show fields |
2,087 |
38.41 |
0.04 % |
show grants |
8 |
0.15 |
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 open tables |
0 |
0.00 |
0.00 % |
show processlist |
2 |
0.04 |
0.00 % |
show slave status |
0 |
0.00 |
0.00 % |
show status |
11 |
0.20 |
0.00 % |
show innodb status |
0 |
0.00 |
0.00 % |
show tables |
72 |
1.33 |
0.00 % |
show variables |
11 |
0.20 |
0.00 % |
slave start |
0 |
0.00 |
0.00 % |
slave stop |
0 |
0.00 |
0.00 % |
truncate |
0 |
0.00 |
0.00 % |
unlock tables |
0 |
0.00 |
0.00 % |
update |
82,449 |
1,517.44 |
1.51 % | |