Submitted by Peter Kim (not verified) on July 15, 2009 - 09:11.
As previously noted, I've been playing with XtraDB a bit at work. Over a week ago I decided to test compression on one of our larger tables and it took a bit longer than I expected. (root@db_server) [db_name]> ALTER TABLE table_name \ ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4; Query OK, 825994826 rows affected (8 days 14 hours 23 min 47.08 sec) Records: 825994826 Duplicates: 0 Warnings: 0 Zoiks! It's too bad we couldn't use all the cores on the machine for the ALTER TABLE,... http://www.p
As previously noted, I've
As previously noted, I've been playing with XtraDB a bit at work. Over a week ago I decided to test compression on one of our larger tables and it took a bit longer than I expected. (root@db_server) [db_name]> ALTER TABLE table_name \ ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4; Query OK, 825994826 rows affected (8 days 14 hours 23 min 47.08 sec) Records: 825994826 Duplicates: 0 Warnings: 0 Zoiks! It's too bad we couldn't use all the cores on the machine for the ALTER TABLE,...
http://www.p