… indexes expand_fast_index_creation gave us a 2.6x speedup. Also note that unlike the default method, where the execution… the table I used in my previous examples): $ mysqldump -uroot test > dump_unoptimized.sql $ mysqldump -uroot test –innodb-optimize-keys > dump_optimized… data from a dump would actually make the restore slower; mysqldump –innodb-optimize-keys ignores indexes on AUTO_INCREMENT columns, because…
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
… from index compression. For test I use dump created with mysqldump, final size 30286M. To create InnoDB compression table I use… to baseline So in conclusion – Fast Index creation allows to speedup load 2 times (even indexes fit into memory) – Load in…
