Dateien hier ablegen
Konsole
| Angaben | # | ø pro Stunde | % |
|---|---|---|---|
| select | 4.061 M | 1.042,8 k | 79,89 |
| set option | 158 M | 40,5 k | 3,10 |
| begin | 138 M | 35,5 k | 2,72 |
| commit | 137 M | 35,3 k | 2,70 |
| update | 124 M | 31,8 k | 2,44 |
| insert | 94.322 k | 24,2 k | 1,86 |
| show fields | 74.094 k | 19 k | 1,46 |
| change db | 62.199 k | 16 k | 1,22 |
| delete | 40.993 k | 10,5 k | <0.01 |
| stmt execute | 35.300 k | 9.064,6 | <0.01 |
| stmt prepare | 35.300 k | 9.064,3 | <0.01 |
| stmt close | 35.289 k | 9.061,6 | <0.01 |
| show tables | 20.691 k | 5.313,2 | <0.01 |
| show table status | 12.687 k | 3.257,9 | <0.01 |
| show triggers | 12.607 k | 3.237,3 | <0.01 |
| show create table | 7.779 k | 1.997,5 | <0.01 |
| rollback to savepoint | 6.392 k | 1.641,3 | <0.01 |
| show status | 6.288 k | 1.614,6 | <0.01 |
| show variables | 3.812 k | 978,9 | <0.01 |
| create table | 2.980 k | 765,1 | <0.01 |
| show keys | 1.608 k | 412,9 | <0.01 |
| update multi | 1.501 k | 385,5 | <0.01 |
| show grants | 1.291 k | 331,6 | <0.01 |
| show warnings | 1.240 k | 318,4 | <0.01 |
| delete multi | 1.208 k | 310,2 | <0.01 |
| show slave status | 1.127 k | 289,5 | <0.01 |
| insert select | 1.096 k | 281,3 | <0.01 |
| rollback | 821 k | 210,9 | <0.01 |
| replace | 658 k | 169,1 | <0.01 |
| show binlogs | 588 k | 151 | <0.01 |
| show slave hosts | 584 k | 150,1 | <0.01 |
| show engine status | 473 k | 121,6 | <0.01 |
| unlock tables | 437 k | 112,3 | <0.01 |
| lock tables | 319 k | 81,8 | <0.01 |
| stmt send long data | 218 k | 56,1 | <0.01 |
| do | 134 k | 34,4 | <0.01 |
| show function status | 113 k | 28,9 | <0.01 |
| show procedure status | 113 k | 28,9 | <0.01 |
| savepoint | 112 k | 28,8 | <0.01 |
| release savepoint | 112 k | 28,8 | <0.01 |
| show events | 112 k | 28,7 | <0.01 |
| show create db | 110 k | 28,2 | <0.01 |
| drop table | 87.832 | 22,6 | <0.01 |
| alter table | 77.007 | 19,8 | <0.01 |
| show charsets | 73.997 | 19 | <0.01 |
| show errors | 53.361 | 13,7 | <0.01 |
| truncate | 46.180 | 11,9 | <0.01 |
| optimize | 12.994 | 3,3 | <0.01 |
| show plugins | 9.242 | 2,4 | <0.01 |
| alter user | 6.496 | 1,7 | <0.01 |
| show create trigger | 4.368 | 1,1 | <0.01 |
| show master status | 4.031 | 1 | <0.01 |
| grant | 3.468 | 0,9 | <0.01 |
| show storage engines | 2.842 | 0,7 | <0.01 |
| revoke all | 2.830 | 0,7 | <0.01 |
| checksum | 2.469 | 0,6 | <0.01 |
| empty query | 1.669 | 0,4 | <0.01 |
| show databases | 1.371 | 0,4 | <0.01 |
| show create func | 788 | 0,2 | <0.01 |
| revoke | 636 | 0,2 | <0.01 |
| purge | 567 | 0,1 | <0.01 |
| drop user | 464 | 0,1 | <0.01 |
| show collations | 294 | 0,1 | <0.01 |
| create user | 276 | 0,1 | <0.01 |
| rename table | 117 | <0,1 | <0.01 |
| create index | 108 | <0,1 | <0.01 |
| drop db | 89 | <0,1 | <0.01 |
| show processlist | 63 | <0,1 | <0.01 |
| repair | 12 | <0,1 | <0.01 |
| create db | 9 | <0,1 | <0.01 |
| flush | 6 | <0,1 | <0.01 |
| drop index | 4 | <0,1 | <0.01 |
| drop function | 2 | <0,1 | <0.01 |
| create trigger | 1 | <0,1 | <0.01 |
| create function | 1 | <0,1 | <0.01 |
| reset | 1 | <0,1 | <0.01 |
| slave stop | 1 | <0,1 | <0.01 |