Dateien hier ablegen
Konsole
| Angaben | # | ø pro Stunde | % |
|---|---|---|---|
| select | 776 M | 310,3 k | 55,12 |
| begin | 136 M | 54,3 k | 9,65 |
| commit | 136 M | 54,2 k | 9,63 |
| update | 76.331 k | 30,5 k | 5,42 |
| set option | 71.862 k | 28,7 k | 5,11 |
| insert | 59.787 k | 23,9 k | 4,25 |
| show fields | 34.208 k | 13,7 k | 2,43 |
| delete | 24.120 k | 9.649,8 | 1,71 |
| change db | 21.714 k | 8.687,3 | 1,54 |
| show table status | 12.613 k | 5.046,2 | <0.01 |
| show triggers | 12.599 k | 5.040,6 | <0.01 |
| stmt execute | 7.073 k | 2.829,9 | <0.01 |
| stmt prepare | 7.073 k | 2.829,7 | <0.01 |
| stmt close | 7.070 k | 2.828,4 | <0.01 |
| show create table | 6.399 k | 2.560,2 | <0.01 |
| rollback to savepoint | 6.315 k | 2.526,5 | <0.01 |
| show tables | 3.521 k | 1.408,7 | <0.01 |
| create table | 2.924 k | 1.169,6 | <0.01 |
| show status | 1.505 k | 602,2 | <0.01 |
| show variables | 858 k | 343,4 | <0.01 |
| show slave status | 768 k | 307,3 | <0.01 |
| show binlogs | 376 k | 150,3 | <0.01 |
| show slave hosts | 375 k | 150 | <0.01 |
| show engine status | 305 k | 121,9 | <0.01 |
| update multi | 275 k | 109,9 | <0.01 |
| unlock tables | 270 k | 108 | <0.01 |
| insert select | 234 k | 93,7 | <0.01 |
| delete multi | 226 k | 90,3 | <0.01 |
| rollback | 180 k | 72,2 | <0.01 |
| lock tables | 153 k | 61,2 | <0.01 |
| show function status | 110 k | 44,2 | <0.01 |
| show procedure status | 110 k | 44,2 | <0.01 |
| savepoint | 110 k | 44,1 | <0.01 |
| release savepoint | 110 k | 44,1 | <0.01 |
| show events | 110 k | 44,1 | <0.01 |
| show create db | 110 k | 44 | <0.01 |
| replace | 84.312 | 33,7 | <0.01 |
| alter table | 66.093 | 26,4 | <0.01 |
| drop table | 56.284 | 22,5 | <0.01 |
| show keys | 48.216 | 19,3 | <0.01 |
| stmt send long data | 42.224 | 16,9 | <0.01 |
| show grants | 37.767 | 15,1 | <0.01 |
| truncate | 29.391 | 11,8 | <0.01 |
| show warnings | 21.874 | 8,8 | <0.01 |
| do | 20.431 | 8,2 | <0.01 |
| show charsets | 14.198 | 5,7 | <0.01 |
| show errors | 10.701 | 4,3 | <0.01 |
| optimize | 8.087 | 3,2 | <0.01 |
| show create trigger | 4.368 | 1,7 | <0.01 |
| show plugins | 3.637 | 1,5 | <0.01 |
| alter user | 3.336 | 1,3 | <0.01 |
| grant | 1.726 | 0,7 | <0.01 |
| revoke all | 1.517 | 0,6 | <0.01 |
| show master status | 845 | 0,3 | <0.01 |
| show storage engines | 811 | 0,3 | <0.01 |
| show create func | 665 | 0,3 | <0.01 |
| checksum | 441 | 0,2 | <0.01 |
| empty query | 236 | 0,1 | <0.01 |
| revoke | 188 | 0,1 | <0.01 |
| drop user | 162 | 0,1 | <0.01 |
| show databases | 159 | 0,1 | <0.01 |
| purge | 122 | <0,1 | <0.01 |
| create index | 101 | <0,1 | <0.01 |
| create user | 76 | <0,1 | <0.01 |
| rename table | 61 | <0,1 | <0.01 |
| show collations | 56 | <0,1 | <0.01 |
| drop db | 34 | <0,1 | <0.01 |
| show processlist | 20 | <0,1 | <0.01 |
| repair | 8 | <0,1 | <0.01 |
| create db | 5 | <0,1 | <0.01 |
| flush | 4 | <0,1 | <0.01 |
| drop index | 3 | <0,1 | <0.01 |
| slave stop | 1 | <0,1 | <0.01 |
| reset | 1 | <0,1 | <0.01 |