… requires table rebuild. Yes you get it right even though Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (Innodb Plugin) dropping foreign keys which should only require meta data change needs a table rebuild…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… with >= MySQL-4.1.1 and stored already) 6353 InnoDB: Page may be an index page where index id is 0 25556 InnoDB: (index “PRIMARY” of table “test”.”test”) InnoDB: Database page… do not you simply rebuild table by using OPTIMIZE TABLE ? This is because Running in innodb_force_recovery mode Innodb becomes read only…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
…/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL This customer was running… that the extra index in Innodb could be removed by doing: ALTER TABLE table_name ENGINE=Innodb; This, of course, rebuilds the whole table…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…sec) mysql> SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name | Value | +——————————+——-+ | Innodb_scan_pages_contiguous | 45 | | Innodb_scan_… it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so be careful with …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… table rebuilds without affecting the table size. mysql> SET expand_fast_index_creation=ON; Query OK, 0 rows affected (0.00 sec) mysql> ALTER… this case InnoDB picks such an index as the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…people do quite frequently with MySQL 
[+] Compact Indexes Compact Indexes are great. Huge indexes is where large portion of Innodb performance problems come however. We…about this feature, for example changing default value needs table rebuild even though for other storage engines it often could …
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
…, PRIMARY KEY (`id`), KEY `c` (`c`) ) ENGINE=InnoDB AUTO_INCREMENT=12582913 DEFAULT CHARSET=latin1 mysql> select * from a order by id limit… table is exposed without indexes for some time. Note though nothing stops you from using LOCK TABLES on Innodb table to ensure… no indexes and bringing box down. You can also use this trick for ALTER TABLE which requires table rebuild. Dropping all indexes; doing…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…_fast_index_creation has been introduced for enabling or disabling this feature. #858945 (Alexey Kopytov). Bugs Fixed InnoDB requires a full table rebuild… as the clustered index by InnoDB in the absence of a PRIMARY KEY. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug fixes in it…_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 key changes. This unnecessarily delays their creation in a mysqldump output, so –innodb-optimize…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been staying at 4.1… this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability… run to show any table / index fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it may…
