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: 10,882,863 Documentation

  • ø per hour: 23,753
  • ø per minute: 396
  • ø per second: 7
Statements # ø per hour %
select 8,408 k 18.4 k 77.26
show fields 549 k 1,197.9 5.04
show tables 467 k 1,019.9 4.29
change db 354 k 773.2 3.26
set option 346 k 755.1 3.18
show keys 319 k 697.1 2.93
show variables 148 k 324 1.36
show create table 75,701 165.2 0.70
show grants 73,058 159.5 0.67
show warnings 72,599 158.5 0.67
replace 29,209 63.8 0.27
insert 16,508 36 0.15
update 5,602 12.2 0.05
stmt execute 3,522 7.7 0.03
stmt prepare 3,429 7.5 0.03
stmt close 3,411 7.4 0.03
show binlogs 1,067 2.3 0.01
show storage engines 919 2 0.01
delete 837 1.8 0.01
unlock tables 672 1.5 0.01
lock tables 648 1.4 0.01
show table status 596 1.3 0.01
show slave status 402 0.9 <0.01
show master status 399 0.9 <0.01
show function status 234 0.5 <0.01
show procedure status 234 0.5 <0.01
show create db 224 0.5 <0.01
show events 224 0.5 <0.01
show package status 224 0.5 <0.01
show package body status 224 0.5 <0.01
alter table 149 0.3 <0.01
create table 126 0.3 <0.01
insert select 53 0.1 <0.01
begin 28 0.1 <0.01
create db 27 0.1 <0.01
commit 26 0.1 <0.01
show status 17 <0.1 <0.01
drop table 10 <0.1 <0.01
flush 8 <0.1 <0.01
truncate 8 <0.1 <0.01
show processlist 2 <0.1 <0.01
show engine status 1 <0.1 <0.01