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,317,057 Documentation

  • ø per hour: 5,867
  • ø per minute: 98
  • ø per second: 2
Statements # ø per hour %
select 2,513 k 4,444.5 75.75
show fields 156 k 275.4 4.69
show tables 145 k 256.4 4.37
change db 111 k 196.8 3.35
set option 89,949 159.1 2.71
stmt close 56,253 99.5 1.70
stmt execute 56,253 99.5 1.70
stmt prepare 56,253 99.5 1.70
show keys 34,641 61.3 1.04
show variables 31,043 54.9 0.94
replace 22,271 39.4 0.67
show create table 20,376 36 0.61
show warnings 13,419 23.7 0.40
insert 4,600 8.1 0.14
show storage engines 3,148 5.6 0.09
show grants 943 1.7 0.03
update 923 1.6 0.03
show table status 882 1.6 0.03
show binlogs 345 0.6 0.01
insert select 323 0.6 0.01
delete 299 0.5 0.01
rollback to savepoint 180 0.3 0.01
show slave status 124 0.2 <0.01
show master status 117 0.2 <0.01
show status 39 0.1 <0.01
create table 15 <0.1 <0.01
alter table 14 <0.1 <0.01
show create proc 14 <0.1 <0.01
show databases 11 <0.1 <0.01
drop procedure 8 <0.1 <0.01
show procedure status 8 <0.1 <0.01
truncate 8 <0.1 <0.01
create procedure 7 <0.1 <0.01
drop table 7 <0.1 <0.01
show function status 6 <0.1 <0.01
create temporary table 5 <0.1 <0.01
drop temporary table 5 <0.1 <0.01
call procedure 4 <0.1 <0.01
flush 2 <0.1 <0.01
show charsets 2 <0.1 <0.01
show collations 2 <0.1 <0.01
show processlist 2 <0.1 <0.01
begin 1 <0.1 <0.01
create db 1 <0.1 <0.01
release savepoint 1 <0.1 <0.01
savepoint 1 <0.1 <0.01
show package status 1 <0.1 <0.01
show package body status 1 <0.1 <0.01
unlock tables 1 <0.1 <0.01