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: 892,280,197 Documentation

  • ø per hour: 10,601,349
  • ø per minute: 176,689
  • ø per second: 2,945
Statements # ø per hour %
stmt execute 309 M 3,673.4 k 34.65
insert 245 M 2,907.5 k 27.43
create table 80,303 k 954.1 k 9.00
stmt prepare 68,041 k 808.4 k 7.63
stmt close 67,895 k 806.7 k 7.61
select 58,002 k 689.1 k 6.50
alter table 41,862 k 497.4 k 4.69
update 10,449 k 124.1 k 1.17
set option 4,593 k 54.6 k 0.51
show fields 3,870 k 46 k 0.43
begin 865 k 10.3 k 0.10
commit 758 k 9,010.1 0.08
show tables 697 k 8,282.6 0.08
delete 400 k 4,749 0.04
show keys 329 k 3,907.9 0.04
rollback 113 k 1,339.7 0.01
change db 66,954 795.5 0.01
show processlist 59,170 703 0.01
show create table 18,939 225 <0.01
show variables 10,972 130.4 <0.01
show databases 8,950 106.3 <0.01
update multi 8,376 99.5 <0.01
show grants 7,398 87.9 <0.01
insert select 6,487 77.1 <0.01
enable governor lve 5,045 59.9 <0.01
show table status 2,677 31.8 <0.01
show warnings 2,641 31.4 <0.01
replace 1,554 18.5 <0.01
flush 1,377 16.4 <0.01
create temporary table 1,090 13 <0.01
drop temporary table 1,066 12.7 <0.01
show storage engines 926 11 <0.01
drop table 695 8.3 <0.01
show triggers 574 6.8 <0.01
grant 537 6.4 <0.01
show function status 405 4.8 <0.01
show procedure status 405 4.8 <0.01
show events 362 4.3 <0.01
show binlogs 328 3.9 <0.01
show binlog status 319 3.8 <0.01
show slave status 319 3.8 <0.01
call procedure 293 3.5 <0.01
rollback to savepoint 236 2.8 <0.01
create index 219 2.6 <0.01
create db 158 1.9 <0.01
create user 137 1.6 <0.01
stmt reprepare 125 1.5 <0.01
drop user 123 1.5 <0.01
show status 106 1.3 <0.01
show charsets 96 1.1 <0.01
delete multi 81 1 <0.01
unlock tables 72 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 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 open tables 9 0.1 <0.01
enable governor reconn lve 8 0.1 <0.01
empty query 7 0.1 <0.01
show engine status 7 0.1 <0.01
create view 2 <0.1 <0.01
revoke 2 <0.1 <0.01
check 1 <0.1 <0.01