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: 4,479,532 Documentation

  • ø per hour: 3,043
  • ø per minute: 51
Statements # ø per hour %
stmt execute 1,274 k 865.7 28.45
update 1,219 k 828.1 27.22
select 1,192 k 809.4 26.60
show keys 152 k 103.6 3.40
set option 140 k 95 3.12
show tables 129 k 87.5 2.88
show fields 112 k 76.3 2.51
change db 64,316 43.7 1.44
stmt prepare 52,112 35.4 1.16
show variables 44,226 30 0.99
show create table 27,975 19 0.62
show warnings 18,348 12.5 0.41
show grants 15,500 10.5 0.35
show create proc 11,692 7.9 0.26
show create func 8,875 6 0.20
create table 6,221 4.2 0.14
show storage engines 4,906 3.3 0.11
stmt close 1,775 1.2 0.04
show binlogs 1,115 0.8 0.02
insert 896 0.6 0.02
show slave status 586 0.4 0.01
show binlog status 566 0.4 0.01
show collations 531 0.4 0.01
show table status 457 0.3 0.01
show status 211 0.1 <0.01
show function status 55 <0.1 <0.01
show procedure status 55 <0.1 <0.01
show triggers 55 <0.1 <0.01
show databases 54 <0.1 <0.01
alter table 34 <0.1 <0.01
show create user 28 <0.1 <0.01
show processlist 19 <0.1 <0.01
flush 16 <0.1 <0.01
show open tables 15 <0.1 <0.01
show engine status 12 <0.1 <0.01
alter user 7 <0.1 <0.01
delete 7 <0.1 <0.01
drop table 4 <0.1 <0.01
empty query 4 <0.1 <0.01
lock tables 4 <0.1 <0.01
unlock tables 4 <0.1 <0.01
create user 3 <0.1 <0.01
grant 3 <0.1 <0.01
create db 1 <0.1 <0.01
create index 1 <0.1 <0.01
drop user 1 <0.1 <0.01
revoke 1 <0.1 <0.01
stmt reprepare 1 <0.1 <0.01