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,577,386 Documentation

  • ø per hour: 20,131
  • ø per minute: 336
  • ø per second: 6
Statements # ø per hour %
select 5,116 k 15.7 k 77.78
show fields 342 k 1,046.4 5.20
show tables 328 k 1,002.5 4.98
set option 229 k 702.2 3.49
change db 219 k 671.2 3.33
show keys 105 k 320 1.59
show variables 64,246 196.6 0.98
show create table 45,095 138 0.69
replace 39,758 121.7 0.60
show grants 33,176 101.5 0.50
show warnings 28,379 86.9 0.43
create table 8,973 27.5 0.14
show storage engines 5,713 17.5 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,045 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 565 1.7 0.01
show slave status 253 0.8 <0.01
show master status 240 0.7 <0.01
begin 168 0.5 <0.01
commit 148 0.5 <0.01
delete 125 0.4 <0.01
show status 58 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 processlist 6 <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
delete multi 1 <0.1 <0.01
lock tables 1 <0.1 <0.01
show databases 1 <0.1 <0.01