Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Questions since startup: 526,117,931 Documentation

  • ø per hour: 707,507
  • ø per minute: 11,792
  • ø per second: 197
Statements # ø per hour %
select 501 M 673.3 k 95.16
set option 7,020 k 9,440.6 1.33
update 6,341 k 8,527 1.21
show fields 3,671 k 4,936.3 0.70
insert 2,753 k 3,702.7 0.52
show tables 2,714 k 3,649.2 0.52
change db 2,091 k 2,812.1 0.40
delete 418 k 562.2 0.08
show keys 326 k 437.7 0.06
show function status 70,806 95.2 0.01
show variables 19,161 25.8 <0.01
show grants 9,389 12.6 <0.01
show create table 8,174 11 <0.01
insert select 8,055 10.8 <0.01
begin 5,203 7 <0.01
commit 5,200 7 <0.01
delete multi 4,623 6.2 <0.01
show storage engines 2,529 3.4 <0.01
show warnings 1,542 2.1 <0.01
rollback to savepoint 1,498 2 <0.01
alter table 468 0.6 <0.01
show table status 463 0.6 <0.01
show binlogs 304 0.4 <0.01
truncate 281 0.4 <0.01
create table 255 0.3 <0.01
drop table 231 0.3 <0.01
unlock tables 162 0.2 <0.01
lock tables 159 0.2 <0.01
show collations 123 0.2 <0.01
show binlog status 100 0.1 <0.01
show slave status 100 0.1 <0.01
show databases 81 0.1 <0.01
show status 40 0.1 <0.01
drop user 26 <0.1 <0.01
revoke 22 <0.1 <0.01
grant 22 <0.1 <0.01
create user 13 <0.1 <0.01
create db 11 <0.1 <0.01
drop db 11 <0.1 <0.01
show charsets 10 <0.1 <0.01
create index 9 <0.1 <0.01
show processlist 5 <0.1 <0.01
show create func 5 <0.1 <0.01
update multi 5 <0.1 <0.01
flush 4 <0.1 <0.01
show engine status 4 <0.1 <0.01
show procedure status 3 <0.1 <0.01
show package body status 3 <0.1 <0.01
show package status 3 <0.1 <0.01
savepoint 3 <0.1 <0.01
release savepoint 3 <0.1 <0.01
show events 3 <0.1 <0.01
kill 2 <0.1 <0.01
load 2 <0.1 <0.01
drop index 1 <0.1 <0.01