Statements | # | ø per hour | % |
---|---|---|---|
Select | 280 k | 165.8 k | 86.36 |
Set Option | 11,925 | 7,070.2 | 3.68 |
Show Tables | 8,386 | 4,971.9 | 2.59 |
Show Fields | 6,446 | 3,821.7 | 1.99 |
Change Db | 5,963 | 3,535.4 | 1.84 |
Show Variables | 3,087 | 1,830.2 | 0.95 |
Show Keys | 1,713 | 1,015.6 | 0.53 |
Show Grants | 1,706 | 1,011.5 | 0.53 |
Show Warnings | 1,177 | 697.8 | 0.36 |
Show Create Table | 1,176 | 697.2 | 0.36 |
Replace | 1,158 | 686.6 | 0.36 |
Show Binlogs | 354 | 209.9 | 0.11 |
Stmt Prepare | 186 | 110.3 | 0.06 |
Show Table Status | 169 | 100.2 | 0.05 |
Update | 137 | 81.2 | 0.04 |
Stmt Close | 102 | 60.5 | 0.03 |
Stmt Execute | 102 | 60.5 | 0.03 |
Show Slave Status | 99 | 58.7 | 0.03 |
Show Master Status | 94 | 55.7 | 0.03 |
Show Storage Engines | 86 | 51 | 0.03 |
Show Status | 42 | 24.9 | 0.01 |
Show Databases | 12 | 7.1 | <0.01 |
Alter Table | 10 | 5.9 | <0.01 |
Create Db | 9 | 5.3 | <0.01 |
Show Profile | 8 | 4.7 | <0.01 |
Create Table | 7 | 4.2 | <0.01 |
Insert | 7 | 4.2 | <0.01 |
Show Binlog Events | 7 | 4.2 | <0.01 |
Show Slave Hosts | 5 | 3 | <0.01 |
Show Engine Status | 4 | 2.4 | <0.01 |
Show Processlist | 4 | 2.4 | <0.01 |
Begin | 2 | 1.2 | <0.01 |
Commit | 2 | 1.2 | <0.01 |