Percona's MySQL & InnoDB performance and scalability blog
Thanks Eric, Though it looks like you do not have 5.0.54 Enterprise yet, Also there are no RPM binaries only RPM…
… also have identical tables created in 5.5.30 where, of course, the only… 1 mysql mysql 98304 Feb 20 15:54 FTS_0000000000000114_0000000000000144_DOC_ID.ibd -rw… | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ I ran OPTIMIZE TABLE several more …
…0 | 0 | 54 | 17855 | index | CLUST_IND | | SYS_IBUF_TABLE_0 | | 53 | 0 | 53 | 72 | 8148 | 0 | 0 | 55 | 17855 | index | CLUST_IND | | SYS_IBUF_TABLE_0 | | 54 | 0 | 54…
… ——–+———————————–+———————————- 149.2 | 119.3 4.8 668.1 1042.5 54.1 | 30.0 5.2 660.9 1048.3 64.6 164.8….1 0.1 0.1 0.7 0.0 1693.7 | 1357.2 0.1 73.6 1480.5 87.1 | 336.5 0.1 0.1 2.1 0.0 1696.2 | 1355.7 0.1 73.8 1520.0 86.4 | 340.4 0.1 0.1 1.5 0.0 [root…
… 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes 0 0 0 0 0 0 0 # Tmp tables 21.36k 0 2 0.01 0 0.11 0 # Tmp disk….81G 0 1.10G 8.69k 15.96k 910.44k 0 # IO r ops 947.67k 0 70.34k 0.54 0.99 56.64 0 # IO r wait 7127s 0 266s 4ms 12ms 238ms 0 # pages…
… into c (a,b) value (1,2),(5,6),(3,9),(122,22),(32,54); > insert into c (a,b) value (1,2),(5,6),(3,9),(122,22),(32,54); about 21x times i run this to… select count(*) from c; +———-+ | count(*) | +———-+ | 20971520 | +———-+ 1 row in set (0.00 sec) > show index from c; +——-+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+ | Table | Non_unique | Key… table is very slow 
Any idea why? My MySQL is 5.0.51a-18 PC: Intel(R) Core(TM)2 Quad CPU…
… *************************** revenue: 446268068091 1 row in set (22.54 sec) mysql> explain select straight…0 | 0 | 90 | 90 | | 5 | Opening tables | 0.270664 | 0.295955 | 0.025996 | 0.024996 | 34 | 35 | 2056 | 1488 | 48 | 48 | | 2 | starting | 0.000230 | 0.000192 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0…
….1 0.5 2.7 0.0 0.4 54% 0 60032.9 sda3 30.0 1.0 0.5 3.0 0.0 0.3 50% 1 66034.0 sda3 23.6 0.8 0.5 3.1 0.0 0… 0.0 0.0 0.0 0.0 0.0 2.5 0% 0 23.2 sdi2 0.0 0.0 0.0 0.0 0.0 2.0 0% 0 23.2 sdj5 0.0 0.0 0.0 0.0 0.0 1.0 0% 0 23.2 sdi4 0.0 0.0 0.0 0.1 0.0 2.2 1% 0 23.2 sdi3 0.0 0.0 0.0 0.1 0.0 2.5…
…% cpu01 14.9% 0.0% 7.5% 0.0% 0.0% 5.9% 71.5% cpu02 10.5% 0.0% 12.5% 0.0% 0.1% 7.1% 69.5% cpu03 12.7% 0.0% 6.7% 0.0% 0.0% 6.7…/c0d0p6 0.27 1.95 2.77 29569906 41860440 cciss/c0d0p7 0.11 0.38 2.16 5719090 32723824 cciss/c0d0p8 0.08 0.54 0.32 8148218 4819040 cciss/c0d0p9 0.00 0.00 0.00 248 0 # vmstat 5…
…5.0.62, 5.0.67 and 5.1.26 versions. One of biggest changes we separated releases of 5.0… ROWS_CHANGED_INDEXES | +————————-+———–+————–+———————-+ | art86.forum86 | 469084 | 54 | 162 | | mysql.db | 36 | 0 | 0 | | art57.link_out57 | 59336163 | 82549 | 577843 …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.