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: 3,178,123 Documentation

  • ø per hour: 9,720
  • ø per minute: 162
  • ø per second: 3
Statements # ø per hour %
select 2,474 k 7,568 77.86
show tables 174 k 533.2 5.49
show fields 161 k 493.1 5.07
change db 122 k 374.5 3.85
set option 92,814 283.9 2.92
show keys 50,578 154.7 1.59
replace 29,132 89.1 0.92
show variables 24,549 75.1 0.77
show create table 18,164 55.6 0.57
show warnings 9,752 29.8 0.31
insert 5,420 16.6 0.17
show storage engines 5,171 15.8 0.16
drop table 1,228 3.8 0.04
begin 1,220 3.7 0.04
commit 1,220 3.7 0.04
create table 1,220 3.7 0.04
stmt prepare 1,010 3.1 0.03
stmt execute 1,004 3.1 0.03
stmt close 1,002 3.1 0.03
show table status 927 2.8 0.03
delete 598 1.8 0.02
show slave status 168 0.5 0.01
show master status 162 0.5 0.01
show grants 49 0.1 <0.01
kill 40 0.1 <0.01
update 34 0.1 <0.01
show binlogs 30 0.1 <0.01
show create proc 28 0.1 <0.01
show status 20 0.1 <0.01
show create func 10 <0.1 <0.01
create trigger 9 <0.1 <0.01
drop trigger 9 <0.1 <0.01
show databases 6 <0.1 <0.01
show engine status 2 <0.1 <0.01
show processlist 2 <0.1 <0.01
alter table 1 <0.1 <0.01
create function 1 <0.1 <0.01
create index 1 <0.1 <0.01
drop function 1 <0.1 <0.01
flush 1 <0.1 <0.01
show charsets 1 <0.1 <0.01
show collations 1 <0.1 <0.01
show create trigger 1 <0.1 <0.01
show function status 1 <0.1 <0.01
show procedure status 1 <0.1 <0.01
update multi 1 <0.1 <0.01