Statements | # | ø per hour | % |
---|---|---|---|
Select | 250 k | 156.4 k | 87.50 |
Set Option | 9,359 | 5,861.6 | 3.28 |
Show Tables | 6,556 | 4,106.1 | 2.30 |
Show Fields | 5,327 | 3,336.3 | 1.87 |
Change Db | 4,792 | 3,001.3 | 1.68 |
Show Variables | 2,423 | 1,517.5 | 0.85 |
Show Keys | 1,547 | 968.9 | 0.54 |
Show Grants | 1,430 | 895.6 | 0.50 |
Show Warnings | 1,063 | 665.8 | 0.37 |
Show Create Table | 1,056 | 661.4 | 0.37 |
Replace | 1,035 | 648.2 | 0.36 |
Update | 233 | 145.9 | 0.08 |
Show Binlogs | 198 | 124 | 0.07 |
Show Table Status | 182 | 114 | 0.06 |
Stmt Prepare | 101 | 63.3 | 0.04 |
Show Slave Status | 88 | 55.1 | 0.03 |
Show Master Status | 87 | 54.5 | 0.03 |
Stmt Close | 59 | 37 | 0.02 |
Stmt Execute | 59 | 37 | 0.02 |
Show Storage Engines | 34 | 21.3 | 0.01 |
Show Status | 33 | 20.7 | 0.01 |
Show Databases | 12 | 7.5 | <0.01 |
Insert | 7 | 4.4 | <0.01 |
Alter Table | 4 | 2.5 | <0.01 |
Create Table | 3 | 1.9 | <0.01 |
Show Processlist | 3 | 1.9 | <0.01 |
Create Db | 2 | 1.3 | <0.01 |
Show Binlog Events | 2 | 1.3 | <0.01 |
Begin | 1 | 0.6 | <0.01 |
Commit | 1 | 0.6 | <0.01 |
Show Slave Hosts | 1 | 0.6 | <0.01 |