Dateien hier ablegen
Konsole
| Angaben | # | ø pro Stunde | % |
|---|---|---|---|
| select | 163 M | 349,8 k | 70,42 |
| begin | 12.894 k | 27,6 k | 5,56 |
| commit | 12.869 k | 27,6 k | 5,55 |
| insert | 9.753 k | 20,9 k | 4,20 |
| set option | 8.399 k | 18 k | 3,62 |
| update | 6.956 k | 14,9 k | 3,00 |
| show fields | 4.135 k | 8.851,8 | 1,78 |
| change db | 2.634 k | 5.639,1 | 1,14 |
| delete | 2.530 k | 5.417 | 1,09 |
| show table status | 1.342 k | 2.872,6 | <0.01 |
| show triggers | 1.336 k | 2.860,8 | <0.01 |
| show tables | 933 k | 1.996,9 | <0.01 |
| stmt prepare | 812 k | 1.739,2 | <0.01 |
| stmt execute | 812 k | 1.739,2 | <0.01 |
| stmt close | 812 k | 1.738,6 | <0.01 |
| show create table | 683 k | 1.462,8 | <0.01 |
| rollback to savepoint | 669 k | 1.432,7 | <0.01 |
| show slave status | 139 k | 297,5 | <0.01 |
| show variables | 127 k | 271,6 | <0.01 |
| alter table | 124 k | 265,1 | <0.01 |
| show status | 74.919 | 160,4 | <0.01 |
| show binlogs | 70.088 | 150,1 | <0.01 |
| show slave hosts | 70.061 | 150 | <0.01 |
| update multi | 63.432 | 135,8 | <0.01 |
| show engine status | 56.842 | 121,7 | <0.01 |
| rollback | 44.331 | 94,9 | <0.01 |
| delete multi | 33.691 | 72,1 | <0.01 |
| insert select | 31.772 | 68 | <0.01 |
| show keys | 30.408 | 65,1 | <0.01 |
| alter db | 28.027 | 60 | <0.01 |
| stmt send long data | 24.569 | 52,6 | <0.01 |
| unlock tables | 23.190 | 49,6 | <0.01 |
| create table | 22.323 | 47,8 | <0.01 |
| lock tables | 11.900 | 25,5 | <0.01 |
| drop table | 11.835 | 25,3 | <0.01 |
| show procedure status | 10.637 | 22,8 | <0.01 |
| show function status | 10.637 | 22,8 | <0.01 |
| show events | 10.455 | 22,4 | <0.01 |
| savepoint | 10.455 | 22,4 | <0.01 |
| release savepoint | 10.455 | 22,4 | <0.01 |
| show create db | 10.420 | 22,3 | <0.01 |
| show errors | 7.292 | 15,6 | <0.01 |
| replace | 4.057 | 8,7 | <0.01 |
| truncate | 2.809 | 6 | <0.01 |
| show create trigger | 2.490 | 5,3 | <0.01 |
| alter user | 1.529 | 3,3 | <0.01 |
| grant | 1.008 | 2,2 | <0.01 |
| optimize | 707 | 1,5 | <0.01 |
| do | 677 | 1,4 | <0.01 |
| revoke | 645 | 1,4 | <0.01 |
| revoke all | 411 | 0,9 | <0.01 |
| drop user | 405 | 0,9 | <0.01 |
| show grants | 388 | 0,8 | <0.01 |
| create user | 295 | 0,6 | <0.01 |
| show master status | 287 | 0,6 | <0.01 |
| show create func | 109 | 0,2 | <0.01 |
| drop db | 51 | 0,1 | <0.01 |
| rename table | 42 | 0,1 | <0.01 |
| empty query | 34 | 0,1 | <0.01 |
| show databases | 34 | 0,1 | <0.01 |
| show create proc | 26 | 0,1 | <0.01 |
| purge | 22 | <0,1 | <0.01 |
| show storage engines | 10 | <0,1 | <0.01 |
| show warnings | 7 | <0,1 | <0.01 |
| flush | 1 | <0,1 | <0.01 |
| show plugins | 1 | <0,1 | <0.01 |
| slave stop | 1 | <0,1 | <0.01 |
| analyze | 1 | <0,1 | <0.01 |
| reset | 1 | <0,1 | <0.01 |