… error and the second ALTER will fail, preventing the creation of the duplicate index. Does it mean that tools like pt-duplicate… DROP INDEX `redundant`, ADD INDEX `redundant` (`col2`); # ######################################################################## # Summary of indexes # ######################################################################## # Size Duplicate Indexes 9 # Total Duplicate Indexes 1 # Total Indexes 2…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the cold test already. The buffer pool and adaptive hash index are cold for the cold test. All tests were done… significantly during the hot run, as hash indexes are faster than a b-tree index. Also accessing pages from the buffer pool… data at the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… secondary index with the same name. Fixed by detecting such cases and omitting the corresponding secondary keys from deferred key creation optimization…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… secondary index with the same name. Fixed by detecting such cases and omitting the corresponding secondary keys from deferred key creation optimization…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… secondary index with the same name. Fixed by detecting such cases and omitting the corresponding secondary keys from deferred key creation optimization…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… table without updating indexes took 18 seconds, and about the same time was spent on rebuilding the index using fast index creation. So we…_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 reported by SHOW TABLE STATUS versus 265 MB index size with the optimization…
Post: Building Indexes by Sorting In Innodb (AKA Fast Index Creation)
June 19, 2012 By 2 Comments
… coded buffer for this operation, which means almost any such index build operation has to use excessive sort merge passes significantly… REBUILD in this table is using “fast_index_creation=0″ which allows to disable fast index creation in Percona Server and force complete table… even for such small table there is possible to improve index creation time 2x by using large buffer. Also we can see…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… I was looking at the ALTER TABLE performance with fast index creation and without it with different buffer pool sizes. Results are… expand_fast_index_creation=1 which builds table with primary key only when creating a table and when builds all indexes by sort… only step which ALTER TABLE does the improvement to the index creation speed itself has to be even larger. It is also…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… deletes are rare). And let’s take index domain_id table: art/link_out104, index: domain_id, space id: 12, root page… 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…
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… (0.00 sec) mysql> select * from innodb_sys_indexes where table_id=13; +———-+———+———-+——+———-+———+——-+ | INDEX_ID | NAME | TABLE_ID | TYPE | N_FIELDS | PAGE… Kopytov which states you also need to set expand_fast_index_creation=1 if you want this feature to work… and indeed…
