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: 167,998,568 Documentation

  • ø per hour: 89,250
  • ø per minute: 1,488
  • ø per second: 25
Statements # ø per hour %
set option 104 M 55.2 k 61.87
select 35,772 k 19 k 21.29
commit 25,734 k 13.7 k 15.32
update 1,371 k 728.6 0.82
show variables 184 k 97.8 0.11
show tables 151 k 80 0.09
show collations 149 k 79 0.09
change db 141 k 74.7 0.08
show fields 114 k 60.4 0.07
show keys 103 k 54.9 0.06
insert 85,761 45.6 0.05
stmt prepare 49,410 26.2 0.03
stmt close 49,408 26.2 0.03
stmt execute 49,408 26.2 0.03
show grants 26,768 14.2 0.02
show create table 24,353 12.9 0.01
delete 16,903 9 0.01
insert select 16,883 9 0.01
show warnings 7,624 4.1 <0.01
show binlogs 5,319 2.8 <0.01
show storage engines 4,231 2.2 <0.01
show table status 1,155 0.6 <0.01
show slave status 312 0.2 <0.01
show master status 292 0.2 <0.01
show status 179 0.1 <0.01
show charsets 33 <0.1 <0.01
show processlist 19 <0.1 <0.01
show databases 18 <0.1 <0.01
show function status 15 <0.1 <0.01
show procedure status 15 <0.1 <0.01
show engine status 13 <0.1 <0.01
flush 9 <0.1 <0.01
create table 2 <0.1 <0.01
rollback 2 <0.1 <0.01
stmt reset 2 <0.1 <0.01
truncate 2 <0.1 <0.01
show triggers 1 <0.1 <0.01