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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





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

Questions since startup: 16,585,522 Documentation

  • ø per hour: 248,071
  • ø per minute: 4,135
  • ø per second: 69
Statements # ø per hour %
select 12,451 k 186.2 k 75.07
show tables 901 k 13.5 k 5.43
show fields 820 k 12.3 k 4.94
change db 590 k 8,824.7 3.56
set option 486 k 7,274.4 2.93
stmt prepare 224 k 3,355.1 1.35
stmt close 224 k 3,354.2 1.35
stmt execute 224 k 3,351 1.35
show keys 196 k 2,928.8 1.18
replace 142 k 2,127.1 0.86
show create table 99,513 1,488.4 0.60
show variables 99,232 1,484.2 0.60
show storage engines 43,122 645 0.26
show warnings 33,983 508.3 0.20
create table 12,316 184.2 0.07
insert 8,422 126 0.05
show table status 7,412 110.9 0.04
update 7,050 105.4 0.04
delete 3,927 58.7 0.02
show grants 3,176 47.5 0.02
insert select 2,806 42 0.02
call procedure 2,702 40.4 0.02
begin 1,495 22.4 0.01
commit 941 14.1 0.01
rollback 613 9.2 <0.01
show slave status 387 5.8 <0.01
show master status 380 5.7 <0.01
show binlogs 105 1.6 <0.01
show status 90 1.3 <0.01
show create proc 80 1.2 <0.01
update multi 11 0.2 <0.01
show databases 9 0.1 <0.01
show function status 9 0.1 <0.01
show procedure status 9 0.1 <0.01
show triggers 9 0.1 <0.01
alter table 6 0.1 <0.01
show open tables 5 0.1 <0.01
show processlist 5 0.1 <0.01
show engine status 4 0.1 <0.01
flush 3 <0.1 <0.01
delete multi 2 <0.1 <0.01
show collations 2 <0.1 <0.01