…_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… 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: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… address this is in XtraDB/InnoDB plugin – fast index creation. With this feature, InnoDB creates indexes by sort, so page fill factor should be… xtrabackup –stats for index domain_id created for table in Barracuda format with Fast creation method: table: art/link_out104, index: domain_id, space…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… database_name/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL… they were adding indexes to the same tables. We had a suspicion that it had something to do with Fast index creation in Innodb… looking at you, Baron) was adverse to trusting INNODB_SYS_INDEXES from some bad experiences with it, and suggested the Innodb…
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
…_BLOCK_SIZE=8 and to test fast index creation I create table only with primary key, without additional indexes. Numbers I got: load dump…, fast index creation6844 (0.74)14968 (0.35) * – ratio to baseline So in conclusion – Fast Index creation allows to speedup load 2 times (even indexes fit…
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… 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… 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: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… amount of pages which do not fit in compressed space. Fast Index Creation This is another feature which I was asking Heikki about… tables may take a lot of time. Fast Index creation will allow Innodb to build indexes by sorting rather by row by row insertions… as for MyISAM tables by separate phase of building Indexes ? Will be UNIQUE indexes built by sorting in case of ALTER TABLE…
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
… “fast index creation” for ALTER TABLE and OPTIMIZE TABLE, which can make these blocking operations much faster and result in less fragmented indexes. He also improved mysqldump so indexes are created with “fast index creation” when restoring a dump, which can…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… innodb_flush_log_at_trx_commit. (Yasufumi Kinoshita) innodb_fast_index_creation – Allows disabling of fast index creation. (Yasufumi Kinoshita) innodb_use_sys_stats_table – If… – Fixes long stalls while accessing the innodb_buffer_pool_pages_index table on systems with a large number of tables. Bug…
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… table could fail due to a bug in innodb_expand_fast_index_creation.patch. (Alexey Kopytov) Bug #764395 – InnoDB crashed with an assertion…
