… 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: 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: 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…
Post: Percona Server 5.5.11-20.2 Stable Release
April 28, 2011 By 1 Comment
… April 11th, 2011. InnoDB fast index creation now works with mysqldump, ALTER TABLE and OPTIMIZE TABLE. (Alexey Kopytov) Variable Changes Variable innodb_extra_rsegments was… an InnoDB table to a MEMORY table could fail due to a bug in innodb_expand_fast_index_creation.patch. (Alexey Kopytov) Bug #764395 – InnoDB crashed…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… were adding indexes to the same tables. We had a suspicion that it had something to do with Fast index creation in Innodb, and that… Innodb thinks is in the Innodb Data dictionary. The first recommendation I got was to simply use the INFORMATION_SCHEMA.INNODB_SYS_INDEXES table…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…: 38530 InnoDB_IO_r_bytes: 631275520 InnoDB_IO_r_wait: 0.204893 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages… really control it (tough it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so be careful with queries scan many records by…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
… new InnoDB pluggable storage engine, which Innobase released at the MySQL conference last month. We’ve written posts ourselves about its fast index creation capabilities and the compressed row format, and how that affects performance. One of the nice things they added in this InnoDB…
Post: Percona Server 5.1.56-12.7
April 18, 2011 By Leave a Comment
… InnoDB fast index creation to mysqldump, ALTER TABLE and, OPTIMIZE TABLE. (Alexey Kopytov) Variables Changed Variable innodb_stats_method has been implemented in the upstream InnoDB… Implemented support for variable innodb_stats_method being implemented in the upstream InnoDB, including adding a column to table INNODB_SYS_STATS. Bug…
