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: 35,555,301 Documentation

  • ø per hour: 42,749
  • ø per minute: 712
  • ø per second: 12
Statements # ø per hour %
select 11,605 k 14 k 32.64
stmt execute 6,770 k 8,139.5 19.04
insert 3,835 k 4,611.3 10.79
stmt prepare 3,625 k 4,358.8 10.20
stmt close 3,622 k 4,354.9 10.19
show fields 2,180 k 2,620.6 6.13
update 1,911 k 2,297.5 5.37
show tables 662 k 796.5 1.86
change db 448 k 538.7 1.26
set option 344 k 414.2 0.97
show keys 198 k 238.5 0.56
show grants 90,702 109.1 0.26
show variables 78,581 94.5 0.22
replace 74,897 90.1 0.21
show create table 53,274 64.1 0.15
show warnings 25,205 30.3 0.07
show storage engines 13,448 16.2 0.04
show binlogs 7,884 9.5 0.02
show table status 4,285 5.2 0.01
delete 1,894 2.3 0.01
show slave status 1,626 2 <0.01
show master status 1,602 1.9 <0.01
alter table 179 0.2 <0.01
truncate 156 0.2 <0.01
show status 140 0.2 <0.01
create table 87 0.1 <0.01
commit 53 0.1 <0.01
begin 52 0.1 <0.01
insert select 20 <0.1 <0.01
flush 20 <0.1 <0.01
show processlist 17 <0.1 <0.01
show engine status 15 <0.1 <0.01
show function status 13 <0.1 <0.01
show procedure status 13 <0.1 <0.01
drop table 12 <0.1 <0.01
grant 9 <0.1 <0.01
create db 7 <0.1 <0.01
alter user 5 <0.1 <0.01
create user 4 <0.1 <0.01
show databases 3 <0.1 <0.01
drop db 3 <0.1 <0.01
rollback 2 <0.1 <0.01
load 2 <0.1 <0.01
drop procedure 2 <0.1 <0.01
delete multi 2 <0.1 <0.01
create procedure 1 <0.1 <0.01
empty query 1 <0.1 <0.01
call procedure 1 <0.1 <0.01
alter db 1 <0.1 <0.01