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: 647,110,151 Documentation

  • ø per hour: 1,836,238
  • ø per minute: 30,604
  • ø per second: 510
Statements # ø per hour %
select 563 M 1,597.5 k 87.00
show fields 20,975 k 59.5 k 3.24
show tables 17,511 k 49.7 k 2.71
change db 13,629 k 38.7 k 2.11
set option 10,481 k 29.7 k 1.62
show variables 6,180 k 17.5 k 0.95
show keys 3,212 k 9,113.7 0.50
show grants 3,100 k 8,796.8 0.48
show create table 3,092 k 8,775.3 0.48
show warnings 3,070 k 8,711.2 0.47
replace 2,742 k 7,781.1 0.42
update 46,589 132.2 0.01
show binlogs 45,521 129.2 0.01
show create proc 14,393 40.8 <0.01
show storage engines 8,713 24.7 <0.01
stmt close 3,011 8.5 <0.01
stmt execute 3,011 8.5 <0.01
stmt prepare 3,011 8.5 <0.01
show table status 1,759 5 <0.01
delete 1,078 3.1 <0.01
insert 1,072 3 <0.01
show slave status 514 1.5 <0.01
show master status 498 1.4 <0.01
create table 317 0.9 <0.01
call procedure 219 0.6 <0.01
show status 79 0.2 <0.01
stmt send long data 47 0.1 <0.01
show charsets 21 0.1 <0.01
show function status 18 0.1 <0.01
show procedure status 18 0.1 <0.01
commit 14 <0.1 <0.01
show databases 12 <0.1 <0.01
create view 10 <0.1 <0.01
drop table 10 <0.1 <0.01
show processlist 8 <0.1 <0.01
alter table 7 <0.1 <0.01
flush 7 <0.1 <0.01
show collations 7 <0.1 <0.01
delete multi 6 <0.1 <0.01
show engine status 5 <0.1 <0.01
show triggers 5 <0.1 <0.01
create procedure 4 <0.1 <0.01
drop procedure 4 <0.1 <0.01
do 3 <0.1 <0.01
rollback 2 <0.1 <0.01
begin 1 <0.1 <0.01
create index 1 <0.1 <0.01