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: 5,250,867 Documentation

  • ø per hour: 50,671
  • ø per minute: 845
  • ø per second: 14
Statements # ø per hour %
select 2,421 k 23.4 k 46.10
set option 2,398 k 23.1 k 45.66
show tables 117 k 1,133 2.24
show fields 101 k 972.2 1.92
change db 84,050 811.1 1.60
commit 34,353 331.5 0.65
show keys 29,701 286.6 0.57
replace 14,494 139.9 0.28
show variables 12,968 125.1 0.25
update 12,074 116.5 0.23
show create table 10,683 103.1 0.20
insert 4,527 43.7 0.09
show storage engines 3,471 33.5 0.07
show warnings 2,783 26.9 0.05
show table status 2,019 19.5 0.04
stmt close 503 4.9 0.01
stmt execute 503 4.9 0.01
stmt prepare 503 4.9 0.01
show grants 376 3.6 0.01
show create proc 359 3.5 0.01
show slave status 215 2.1 <0.01
show master status 212 2 <0.01
show triggers 116 1.1 <0.01
show binlogs 69 0.7 <0.01
show collations 51 0.5 <0.01
call procedure 39 0.4 <0.01
delete 37 0.4 <0.01
release savepoint 34 0.3 <0.01
savepoint 34 0.3 <0.01
show status 24 0.2 <0.01
kill 15 0.1 <0.01
show create trigger 15 0.1 <0.01
show create func 14 0.1 <0.01
show databases 14 0.1 <0.01
show function status 12 0.1 <0.01
show procedure status 12 0.1 <0.01
empty query 6 0.1 <0.01
show create db 6 0.1 <0.01
show processlist 4 <0.1 <0.01
alter table 3 <0.1 <0.01
insert select 3 <0.1 <0.01
create table 2 <0.1 <0.01
drop temporary table 2 <0.1 <0.01
create temporary table 1 <0.1 <0.01
show engine status 1 <0.1 <0.01
show open tables 1 <0.1 <0.01