Statements | # | ø per hour | % |
---|---|---|---|
Select | 34,987 | 186.9 k | 55.90 |
Set Option | 9,446 | 50.5 k | 15.09 |
Change Db | 5,247 | 28 k | 8.38 |
Show Tables | 4,796 | 25.6 k | 7.66 |
Show Variables | 1,920 | 10.3 k | 3.07 |
Show Grants | 1,753 | 9,363.2 | 2.80 |
Show Fields | 1,145 | 6,115.7 | 1.83 |
Show Keys | 746 | 3,984.6 | 1.19 |
Show Warnings | 581 | 3,103.3 | 0.93 |
Show Create Table | 569 | 3,039.2 | 0.91 |
Show Binlogs | 421 | 2,248.7 | 0.67 |
Show Table Status | 194 | 1,036.2 | 0.31 |
Show Master Status | 163 | 870.6 | 0.26 |
Show Slave Status | 163 | 870.6 | 0.26 |
Create Table | 63 | 336.5 | 0.10 |
Stmt Execute | 60 | 320.5 | 0.10 |
Stmt Close | 60 | 320.5 | 0.10 |
Stmt Prepare | 60 | 320.5 | 0.10 |
Show Storage Engines | 55 | 293.8 | 0.09 |
Alter Table | 27 | 144.2 | 0.04 |
Show Create Proc | 27 | 144.2 | 0.04 |
Show Create Func | 22 | 117.5 | 0.04 |
Create Db | 18 | 96.1 | 0.03 |
Show Status | 17 | 90.8 | 0.03 |
Insert | 14 | 74.8 | 0.02 |
Delete | 8 | 42.7 | 0.01 |
Drop Table | 8 | 42.7 | 0.01 |
Flush | 5 | 26.7 | 0.01 |
Show Slave Hosts | 4 | 21.4 | 0.01 |
Begin | 3 | 16 | <0.01 |
Show Binlog Events | 3 | 16 | <0.01 |
Show Processlist | 3 | 16 | <0.01 |
Alter User | 1 | 5.3 | <0.01 |
Commit | 1 | 5.3 | <0.01 |
Create User | 1 | 5.3 | <0.01 |
Drop Db | 1 | 5.3 | <0.01 |
Grant | 1 | 5.3 | <0.01 |
Show Profile | 1 | 5.3 | <0.01 |