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,310,671 Documentation

  • ø per hour: 3,914
  • ø per minute: 65
  • ø per second: 1
Statements # ø per hour %
select 2,552 k 3,016.9 77.09
show tables 174 k 206.3 5.27
show fields 165 k 195.3 4.99
change db 123 k 145.7 3.72
set option 93,733 110.8 2.83
show keys 49,560 58.6 1.50
replace 26,740 31.6 0.81
stmt execute 23,062 27.3 0.70
stmt prepare 21,949 25.9 0.66
show create table 20,380 24.1 0.62
stmt close 17,844 21.1 0.54
show variables 17,689 20.9 0.53
show storage engines 8,726 10.3 0.26
show warnings 6,092 7.2 0.18
insert 2,755 3.3 0.08
alter table 2,070 2.4 0.06
show table status 1,400 1.7 0.04
show grants 587 0.7 0.02
update 576 0.7 0.02
delete 519 0.6 0.02
show create db 461 0.5 0.01
show slave status 311 0.4 0.01
show master status 304 0.4 0.01
begin 153 0.2 <0.01
commit 153 0.2 <0.01
create table 136 0.2 <0.01
insert select 91 0.1 <0.01
show binlogs 90 0.1 <0.01
show function status 56 0.1 <0.01
show procedure status 56 0.1 <0.01
show triggers 45 0.1 <0.01
show status 42 <0.1 <0.01
do 33 <0.1 <0.01
lock tables 22 <0.1 <0.01
unlock tables 22 <0.1 <0.01
update multi 22 <0.1 <0.01
show create proc 18 <0.1 <0.01
show package status 11 <0.1 <0.01
show package body status 11 <0.1 <0.01
show databases 10 <0.1 <0.01
show open tables 5 <0.1 <0.01
show collations 4 <0.1 <0.01
show processlist 4 <0.1 <0.01
show engine status 3 <0.1 <0.01
show charsets 2 <0.1 <0.01
create db 1 <0.1 <0.01
drop db 1 <0.1 <0.01
rename table 1 <0.1 <0.01