…, expand_fast_index_creation may also optimize index access for subsequent DML statements. In my test setup I got about 178 MB index size after fast index creation as…, InnoDB fast index creation uses temporary files in tmpdir for all indexes being created. So make sure you have enough tmpdir space when using expand_fast_index_creation…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… changes The Fast Index Creation Feature has been disabled by default to align the behavior with upstream. The boolean variable innodb_expand_fast_index_creation has been… key constrains. #859078 (Alexey Kopytov). After adding an index using Fast Index Creation, statistics for that index provided by InnoDB were left in a bogus…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… changes The Fast Index Creation Feature has been disabled by default to align the behavior with upstream. The boolean variable innodb_expand_fast_index_creation has been… key constrains. #859078 (Alexey Kopytov). After adding an index using Fast Index Creation, statistics for that index provided by InnoDB were left in a bogus…
Post: Percona Server 5.5.11-20.2 Stable Release
April 28, 2011 By 1 Comment
… to the latest stable version as April 11th, 2011. InnoDB fast index creation now works with mysqldump, ALTER TABLE and OPTIMIZE TABLE. (Alexey… MEMORY table could fail due to a bug in innodb_expand_fast_index_creation.patch. (Alexey Kopytov) Bug #764395 – InnoDB crashed with an assertion…
Comment: Improved InnoDB fast index creation
November 7, 2011 By 4 Comments
Hi Alexey expand_fast_index_creation sys var doesnt exist on 5.5.12… your blog post says >=5.5.11 am I missing something?
Post: Percona Server 5.1.56-12.7
April 18, 2011 By Leave a Comment
… release in the 5.1 series. New Features Expanded the applicability of InnoDB fast index creation to mysqldump, ALTER TABLE and, OPTIMIZE TABLE. (Alexey… a server crash. (Yasufumi Kinoshita) Bug #727704 – When using the Expand Table Import feature, importing .ibd files created on MySQL 5…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… Features – XtraDB is derived from the InnoDB plugin, which has fast index creation (as opposed to recreating the whole table!) and page compression… allows you to delay the writing of non-unique secondary index pages, which can often lead to a lot of merged… 1023 (see bug report). Â XtraDB allows this to be expanded to 4072 (Warning: Incompatible change!). Â (see docs). All of…
