… adaptive hash index is improving performance of InnoDB significantly during the hot run, as hash indexes are faster than a b-tree index. Also… caching of data at the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… the fast index creation feature introduced in the InnoDB plugin is that it only works when indexes are explicitly created using ALTER TABLE or CREATE INDEX…, 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: Building Indexes by Sorting In Innodb (AKA Fast Index Creation)
June 19, 2012 By 2 Comments
… sec REBUILD in this table is using “fast_index_creation=0″ which allows to disable fast index creation in Percona Server and force complete table to… to building index by sort with small buffer – this comes from building index on long character field with very short length, Innodb would…
Post: Using innodb_sys_tables and innodb_sys_indexes
June 15, 2012 By Leave a Comment
I was playing with Percona Server today and found fast_index_creation does not work quite exactly like described in the manual. … sort. Looking at innodb_sys_tables and innodb_sys_indexes I discovered it is not the case: mysql> select * from innodb_sys_tables; +———-+——–+——————+——+——–+——-+ | TABLE… to set expand_fast_index_creation=1 if you want this feature to work… and indeed it does. mysql> select * from innodb_sys_tables…
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
… size 30286M. To create InnoDB compression table I use ENGINE=InnoDB KEY_BLOCK_SIZE=8 and to test fast index creation I create table only with primary key, without additional indexes. Numbers I…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB Version: 10 …with expand_fast_index_creation=1 which builds table with primary key only when creating a table and when builds all indexes by …
Comment: Announcing Percona Server 5.6 Alpha
August 14, 2012 By 2 Comments
It is the addition of the fast_index_creation variable: http://www.percona.com/doc/percona-server/5.5/management/innodb_fast_index_creation.html?highlight=fast_index_creation#fast_index_creation
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… compressed space. Fast Index Creation This is another feature which I was asking Heikki about probably since my first days as Innodb user when I found out ALTERing Innodb tables may take a lot of time. Fast Index creation will allow Innodb to build indexes by…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… new feature to address this is in XtraDB/InnoDB plugin – fast index creation. With this feature, InnoDB creates indexes by sort, so page fill factor should… 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: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… MySQL global system variable 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… Bug #576041 – Fixes long stalls while accessing the innodb_buffer_pool_pages_index table on systems with a large number of tables…
