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: 6,513,371 Documentation

  • ø per hour: 19,937
  • ø per minute: 332
  • ø per second: 6
Statements # ø per hour %
select 5,065 k 15.5 k 77.76
show fields 339 k 1,036.3 5.20
show tables 325 k 995 4.99
set option 228 k 697.9 3.50
change db 217 k 665.1 3.34
show keys 103 k 316.5 1.59
show variables 63,412 194.1 0.97
show create table 44,662 136.7 0.69
replace 39,537 121 0.61
show grants 32,752 100.3 0.50
show warnings 27,988 85.7 0.43
create table 8,973 27.5 0.14
show storage engines 5,676 17.4 0.09
insert 3,575 10.9 0.05
update 2,273 7 0.03
rollback to savepoint 2,174 6.7 0.03
show table status 1,040 3.2 0.02
stmt close 895 2.7 0.01
stmt execute 895 2.7 0.01
stmt prepare 895 2.7 0.01
show binlogs 553 1.7 0.01
show slave status 248 0.8 <0.01
show master status 235 0.7 <0.01
begin 168 0.5 <0.01
commit 148 0.5 <0.01
delete 125 0.4 <0.01
show status 53 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
alter table 5 <0.1 <0.01
flush 5 <0.1 <0.01
rollback 5 <0.1 <0.01
show engine status 5 <0.1 <0.01
show processlist 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