… fast index creation as reported by SHOW TABLE STATUS versus 265 MB index size with the optimization disabled. OPTIMIZE TABLE OPTIMIZE TABLE is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables and thus, is just a special case of the previous one: mysql> SET expand_fast_index_creation…
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
…CHARSET=utf8, which seems not working with fast index creation (bug 33650) , so I use latin1 for tests. Also we actually store ‘bodyuc’ … 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…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…feature to address this is in XtraDB/InnoDB plugin – fast index creation. With this feature, InnoDB creates indexes by sort, so page fill factor… there is xtrabackup –stats for index domain_id created for table in Barracuda format with Fast creation method: table: art/link_out104, index: domain_id, …
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… they 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… to trusting INNODB_SYS_INDEXES from some bad experiences with it, and suggested the Innodb Table monitor instead, see my next post for how that…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…single page size for Innodb table, while data pages and pages for different indexes may well have very different compression ratio. As Innodb indexes are not …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: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…InnoDB Table has 11864696 rows and takes Data_length: 698,351,616 bytes on disk The problem is that after restoring table…InnoDB-plugin with FAST INDEX creation…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… variable innodb_expand_fast_index_creation has been introduced for enabling or disabling this feature. #858945 (Alexey Kopytov). Bugs Fixed InnoDB requires a full table rebuild for foreign… adding an index using Fast Index Creation, statistics for that index provided by InnoDB were left in a bogus state until an explicit ANALYZE TABLE is executed. #857590…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… variable innodb_expand_fast_index_creation has been introduced for enabling or disabling this feature. #858945 (Alexey Kopytov). Bugs Fixed InnoDB requires a full table rebuild for foreign… adding an index using Fast Index Creation, statistics for that index provided by InnoDB were left in a bogus state until an explicit ANALYZE TABLE is executed. #857590…
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 ON, the table…Pecona-discussions group, and for development questions our Percona-dev group. For support, commercial, and …
Post: Percona Server 5.5.11-20.2 Stable Release
April 28, 2011 By 1 Comment
… for MySQL, has been updated to the latest stable version as April 11th, 2011. InnoDB fast index creation now works with mysqldump, ALTER TABLE and OPTIMIZE TABLE… ALTER TABLE to convert 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…
