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: 8,954,029 Documentation

  • ø per hour: 27,274
  • ø per minute: 455
  • ø per second: 8
Statements # ø per hour %
select 7,056 k 21.5 k 78.80
show fields 452 k 1,376.5 5.05
show tables 417 k 1,269.6 4.65
change db 290 k 883.6 3.24
set option 283 k 860.5 3.16
show keys 124 k 377.8 1.39
show variables 98,527 300.1 1.10
show create table 62,580 190.6 0.70
show grants 50,320 153.3 0.56
replace 47,476 144.6 0.53
show warnings 45,390 138.3 0.51
create table 8,973 27.3 0.10
show storage engines 5,836 17.8 0.07
insert 3,575 10.9 0.04
update 2,273 6.9 0.03
rollback to savepoint 2,174 6.6 0.02
show table status 1,061 3.2 0.01
stmt close 949 2.9 0.01
stmt execute 949 2.9 0.01
stmt prepare 949 2.9 0.01
show binlogs 620 1.9 0.01
show slave status 258 0.8 <0.01
show master status 245 0.7 <0.01
begin 168 0.5 <0.01
commit 148 0.5 <0.01
delete 125 0.4 <0.01
show status 67 0.2 <0.01
unlock tables 16 <0.1 <0.01
release savepoint 15 <0.1 <0.01
savepoint 15 <0.1 <0.01
show create db 15 <0.1 <0.01
show function status 15 <0.1 <0.01
show package status 15 <0.1 <0.01
show package body status 15 <0.1 <0.01
show procedure status 15 <0.1 <0.01
show engine status 8 <0.1 <0.01
show processlist 7 <0.1 <0.01
flush 6 <0.1 <0.01
alter table 5 <0.1 <0.01
rollback 5 <0.1 <0.01
delete multi 1 <0.1 <0.01
lock tables 1 <0.1 <0.01
show databases 1 <0.1 <0.01