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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Questions since startup: 895,899,712 Documentation

  • ø per hour: 10,547,649
  • ø per minute: 175,794
  • ø per second: 2,930
Statements # ø per hour %
stmt execute 310 M 3,653.6 k 34.64
insert 246 M 2,890.9 k 27.41
create table 80,567 k 948.5 k 8.99
stmt prepare 68,367 k 804.9 k 7.63
stmt close 68,222 k 803.2 k 7.61
select 58,385 k 687.4 k 6.52
alter table 41,998 k 494.5 k 4.69
update 10,515 k 123.8 k 1.17
set option 4,625 k 54.5 k 0.52
show fields 3,899 k 45.9 k 0.44
begin 872 k 10.3 k 0.10
commit 765 k 9,011.8 0.09
show tables 718 k 8,454 0.08
delete 403 k 4,741 0.04
show keys 342 k 4,020.7 0.04
rollback 113 k 1,327.6 0.01
change db 74,919 882 0.01
show processlist 59,729 703.2 0.01
show create table 22,875 269.3 <0.01
show variables 11,742 138.2 <0.01
show databases 8,950 105.4 <0.01
update multi 8,433 99.3 <0.01
show grants 7,552 88.9 <0.01
insert select 6,488 76.4 <0.01
enable governor lve 5,092 59.9 <0.01
show warnings 2,917 34.3 <0.01
show table status 2,763 32.5 <0.01
replace 1,554 18.3 <0.01
flush 1,386 16.3 <0.01
create temporary table 1,102 13 <0.01
drop temporary table 1,078 12.7 <0.01
show storage engines 1,004 11.8 <0.01
drop table 695 8.2 <0.01
show triggers 574 6.8 <0.01
grant 537 6.3 <0.01
show function status 405 4.8 <0.01
show procedure status 405 4.8 <0.01
show binlogs 370 4.4 <0.01
show events 362 4.3 <0.01
show binlog status 329 3.9 <0.01
show slave status 329 3.9 <0.01
call procedure 293 3.4 <0.01
rollback to savepoint 236 2.8 <0.01
create index 219 2.6 <0.01
create db 159 1.9 <0.01
create user 137 1.6 <0.01
stmt reprepare 125 1.5 <0.01
drop user 123 1.4 <0.01
show status 118 1.4 <0.01
show charsets 96 1.1 <0.01
delete multi 81 1 <0.01
unlock tables 72 0.8 <0.01
lock tables 58 0.7 <0.01
alter user 33 0.4 <0.01
truncate 30 0.4 <0.01
savepoint 29 0.3 <0.01
drop db 19 0.2 <0.01
release savepoint 14 0.2 <0.01
drop index 11 0.1 <0.01
show package status 10 0.1 <0.01
show package body status 10 0.1 <0.01
show engine status 9 0.1 <0.01
show open tables 9 0.1 <0.01
enable governor reconn lve 8 0.1 <0.01
empty query 7 0.1 <0.01
create view 2 <0.1 <0.01
revoke 2 <0.1 <0.01
check 1 <0.1 <0.01