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: 135,717,987 Documentation

  • ø per hour: 89,516
  • ø per minute: 1,492
  • ø per second: 25
Statements # ø per hour %
set option 83,648 k 55.2 k 61.63
select 29,268 k 19.3 k 21.57
commit 20,716 k 13.7 k 15.26
update 1,103 k 727.3 0.81
show variables 148 k 97.5 0.11
show tables 124 k 82 0.09
show collations 120 k 79 0.09
change db 112 k 73.9 0.08
show fields 88,557 58.4 0.07
show keys 80,884 53.3 0.06
insert 76,114 50.2 0.06
stmt prepare 49,249 32.5 0.04
stmt close 49,247 32.5 0.04
stmt execute 49,247 32.5 0.04
show grants 24,512 16.2 0.02
show create table 19,693 13 0.01
delete 13,035 8.6 0.01
insert select 13,019 8.6 0.01
show warnings 6,911 4.6 0.01
show storage engines 3,478 2.3 <0.01
show binlogs 3,428 2.3 <0.01
show table status 967 0.6 <0.01
show slave status 253 0.2 <0.01
show master status 236 0.2 <0.01
show status 144 0.1 <0.01
show charsets 27 <0.1 <0.01
show processlist 16 <0.1 <0.01
show databases 12 <0.1 <0.01
show function status 12 <0.1 <0.01
show procedure status 12 <0.1 <0.01
show engine status 9 <0.1 <0.01
flush 7 <0.1 <0.01
create table 2 <0.1 <0.01
stmt reset 2 <0.1 <0.01
truncate 2 <0.1 <0.01
rollback 1 <0.1 <0.01
show triggers 1 <0.1 <0.01