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: 10,327,576 Documentation

  • ø per hour: 36,651
  • ø per minute: 611
  • ø per second: 10
Statements # ø per hour %
select 7,933 k 28.2 k 76.82
show tables 536 k 1,902.7 5.19
show fields 527 k 1,868.9 5.10
change db 396 k 1,404 3.83
set option 376 k 1,335.1 3.64
show keys 160 k 566.9 1.55
replace 93,240 330.9 0.90
show variables 86,774 307.9 0.84
show create table 65,180 231.3 0.63
insert 40,839 144.9 0.40
show warnings 36,444 129.3 0.35
stmt execute 17,045 60.5 0.17
stmt prepare 16,815 59.7 0.16
stmt close 16,773 59.5 0.16
show storage engines 14,724 52.3 0.14
update 2,568 9.1 0.02
show table status 2,437 8.6 0.02
delete 2,290 8.1 0.02
show grants 928 3.3 0.01
create table 746 2.6 0.01
begin 675 2.4 0.01
drop table 675 2.4 0.01
commit 674 2.4 0.01
show slave status 353 1.3 <0.01
show master status 343 1.2 <0.01
show binlogs 212 0.8 <0.01
show status 65 0.2 <0.01
show create proc 50 0.2 <0.01
alter table 25 0.1 <0.01
kill 16 0.1 <0.01
insert select 9 <0.1 <0.01
show processlist 8 <0.1 <0.01
flush 5 <0.1 <0.01
show databases 5 <0.1 <0.01
show engine status 4 <0.1 <0.01
create trigger 3 <0.1 <0.01
drop trigger 3 <0.1 <0.01
create db 2 <0.1 <0.01
create temporary table 2 <0.1 <0.01
create user 2 <0.1 <0.01
grant 2 <0.1 <0.01
show charsets 1 <0.1 <0.01
show collations 1 <0.1 <0.01