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: 886,676,614 Documentation

  • ø per hour: 10,667,927
  • ø per minute: 177,799
  • ø per second: 2,963
Statements # ø per hour %
stmt execute 307 M 3,698.9 k 34.67
insert 244 M 2,929.6 k 27.46
create table 79,820 k 960.3 k 9.00
stmt prepare 67,491 k 812 k 7.61
stmt close 67,346 k 810.3 k 7.60
select 57,424 k 690.9 k 6.48
alter table 41,598 k 500.5 k 4.69
update 10,357 k 124.6 k 1.17
set option 4,551 k 54.8 k 0.51
show fields 3,836 k 46.2 k 0.43
begin 856 k 10.3 k 0.10
commit 749 k 9,008.4 0.08
show tables 682 k 8,210.8 0.08
delete 396 k 4,766.6 0.04
show keys 318 k 3,829.2 0.04
rollback 113 k 1,356.6 0.01
change db 61,486 739.8 0.01
show processlist 58,419 702.9 0.01
show create table 16,421 197.6 <0.01
show variables 10,243 123.2 <0.01
show databases 8,950 107.7 <0.01
update multi 8,295 99.8 <0.01
show grants 7,149 86 <0.01
insert select 6,478 77.9 <0.01
enable governor lve 4,982 59.9 <0.01
show table status 2,662 32 <0.01
show warnings 2,628 31.6 <0.01
replace 1,554 18.7 <0.01
flush 1,371 16.5 <0.01
create temporary table 1,090 13.1 <0.01
drop temporary table 1,066 12.8 <0.01
show storage engines 833 10 <0.01
drop table 695 8.4 <0.01
show triggers 569 6.8 <0.01
grant 537 6.5 <0.01
show function status 405 4.9 <0.01
show procedure status 405 4.9 <0.01
show events 362 4.4 <0.01
call procedure 293 3.5 <0.01
show binlog status 287 3.5 <0.01
show slave status 287 3.5 <0.01
rollback to savepoint 231 2.8 <0.01
create index 219 2.6 <0.01
create db 158 1.9 <0.01
show binlogs 141 1.7 <0.01
create user 137 1.6 <0.01
stmt reprepare 125 1.5 <0.01
drop user 123 1.5 <0.01
show charsets 96 1.2 <0.01
delete multi 81 1 <0.01
show status 76 0.9 <0.01
unlock tables 71 0.9 <0.01
lock tables 58 0.7 <0.01
alter user 32 0.4 <0.01
truncate 30 0.4 <0.01
savepoint 28 0.3 <0.01
drop db 19 0.2 <0.01
release savepoint 13 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 open tables 9 0.1 <0.01
enable governor reconn lve 8 0.1 <0.01
empty query 6 0.1 <0.01
show engine status 5 0.1 <0.01
create view 2 <0.1 <0.01
revoke 2 <0.1 <0.01
check 1 <0.1 <0.01