Letakkan berkas disini
Konsol
| Keterangan | # | ø per hour | % |
|---|---|---|---|
| select | 31,627 k | 101.4 k | 67.49 |
| change db | 9,958 k | 31.9 k | 21.25 |
| show tables | 1,166 k | 3,737.9 | 2.49 |
| insert | 1,036 k | 3,321.8 | 2.21 |
| set option | 896 k | 2,875 | 1.91 |
| show fields | 744 k | 2,387.4 | 1.59 |
| show variables | 329 k | 1,055.6 | 0.70 |
| show keys | 270 k | 866.3 | 0.58 |
| show create table | 202 k | 647 | 0.43 |
| replace | 162 k | 519.5 | 0.35 |
| show warnings | 144 k | 463 | 0.31 |
| delete | 103 k | 329.7 | 0.22 |
| update | 88,433 | 283.6 | 0.19 |
| show table status | 61,898 | 198.5 | 0.13 |
| show storage engines | 32,738 | 105 | 0.07 |
| commit | 20,500 | 65.7 | 0.04 |
| stmt execute | 10,015 | 32.1 | 0.02 |
| stmt prepare | 5,504 | 17.7 | 0.01 |
| stmt close | 4,900 | 15.7 | 0.01 |
| rollback | 346 | 1.1 | <0.01 |
| alter table | 242 | 0.8 | <0.01 |
| show slave status | 183 | 0.6 | <0.01 |
| show master status | 179 | 0.6 | <0.01 |
| create table | 142 | 0.5 | <0.01 |
| truncate | 119 | 0.4 | <0.01 |
| show grants | 108 | 0.3 | <0.01 |
| show binlogs | 79 | 0.3 | <0.01 |
| lock tables | 13 | <0.1 | <0.01 |
| show status | 13 | <0.1 | <0.01 |
| unlock tables | 13 | <0.1 | <0.01 |
| show function status | 6 | <0.1 | <0.01 |
| show package status | 6 | <0.1 | <0.01 |
| show package body status | 6 | <0.1 | <0.01 |
| show procedure status | 6 | <0.1 | <0.01 |
| begin | 1 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |