Angaben | # | ø pro Stunde | % |
---|---|---|---|
select | 2.273 M | 606,3 k | 83,85 |
set option | 69.838 k | 18,6 k | 2,58 |
update | 57.488 k | 15,3 k | 2,12 |
insert | 52.176 k | 13,9 k | 1,92 |
show fields | 36.368 k | 9.699,5 | 1,34 |
stmt execute | 31.880 k | 8.502,7 | 1,18 |
stmt prepare | 31.875 k | 8.501,3 | 1,18 |
stmt close | 31.875 k | 8.501,2 | 1,18 |
change db | 28.512 k | 7.604,3 | 1,05 |
commit | 25.523 k | 6.807,2 | <0.01 |
begin | 25.462 k | 6.790,8 | <0.01 |
delete | 16.209 k | 4.323 | <0.01 |
show tables | 10.172 k | 2.712,8 | <0.01 |
show status | 3.035 k | 809,4 | <0.01 |
show table status | 2.986 k | 796,3 | <0.01 |
show triggers | 2.906 k | 775,1 | <0.01 |
show create table | 1.645 k | 438,6 | <0.01 |
rollback to savepoint | 1.450 k | 386,8 | <0.01 |
delete multi | 1.019 k | 271,9 | <0.01 |
show slave status | 1.012 k | 270 | <0.01 |
show variables | 1.011 k | 269,7 | <0.01 |
create table | 889 k | 237 | <0.01 |
show binlogs | 563 k | 150,1 | <0.01 |
show slave hosts | 562 k | 150 | <0.01 |
rollback | 527 k | 140,6 | <0.01 |
show engine status | 455 k | 121,2 | <0.01 |
alter table | 446 k | 119,1 | <0.01 |
stmt send long data | 439 k | 117,1 | <0.01 |
insert select | 309 k | 82,5 | <0.01 |
show keys | 288 k | 76,9 | <0.01 |
alter db | 226 k | 60,3 | <0.01 |
replace | 194 k | 51,8 | <0.01 |
unlock tables | 82.789 | 22,1 | <0.01 |
lock tables | 61.906 | 16,5 | <0.01 |
drop table | 56.796 | 15,1 | <0.01 |
show errors | 48.332 | 12,9 | <0.01 |
truncate | 25.406 | 6,8 | <0.01 |
show function status | 24.376 | 6,5 | <0.01 |
show procedure status | 24.376 | 6,5 | <0.01 |
savepoint | 20.423 | 5,4 | <0.01 |
release savepoint | 20.419 | 5,4 | <0.01 |
show events | 20.173 | 5,4 | <0.01 |
show create db | 20.172 | 5,4 | <0.01 |
update multi | 15.783 | 4,2 | <0.01 |
show grants | 12.032 | 3,2 | <0.01 |
optimize | 10.708 | 2,9 | <0.01 |
show master status | 5.980 | 1,6 | <0.01 |
show warnings | 3.117 | 0,8 | <0.01 |
do | 2.824 | 0,8 | <0.01 |
alter user | 2.796 | 0,7 | <0.01 |
show plugins | 2.626 | 0,7 | <0.01 |
grant | 1.474 | 0,4 | <0.01 |
revoke all | 1.273 | 0,3 | <0.01 |
show databases | 632 | 0,2 | <0.01 |
empty query | 518 | 0,1 | <0.01 |
show storage engines | 419 | 0,1 | <0.01 |
purge | 407 | 0,1 | <0.01 |
show charsets | 304 | 0,1 | <0.01 |
checksum | 270 | 0,1 | <0.01 |
revoke | 226 | 0,1 | <0.01 |
show create func | 180 | <0,1 | <0.01 |
drop user | 150 | <0,1 | <0.01 |
show create trigger | 144 | <0,1 | <0.01 |
create user | 100 | <0,1 | <0.01 |
show create proc | 70 | <0,1 | <0.01 |
rename table | 50 | <0,1 | <0.01 |
create index | 42 | <0,1 | <0.01 |
show collations | 34 | <0,1 | <0.01 |
drop db | 23 | <0,1 | <0.01 |
drop index | 15 | <0,1 | <0.01 |
kill | 12 | <0,1 | <0.01 |
drop function | 10 | <0,1 | <0.01 |
create trigger | 5 | <0,1 | <0.01 |
create function | 5 | <0,1 | <0.01 |
show processlist | 5 | <0,1 | <0.01 |
flush | 3 | <0,1 | <0.01 |
slave stop | 2 | <0,1 | <0.01 |
check | 2 | <0,1 | <0.01 |
reset | 2 | <0,1 | <0.01 |
repair | 1 | <0,1 | <0.01 |
slave start | 1 | <0,1 | <0.01 |
create db | 1 | <0,1 | <0.01 |
change master | 1 | <0,1 | <0.01 |
analyze | 1 | <0,1 | <0.01 |