… in Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database page corruption on disk or a failed InnoDB: file… simple Innodb Table Corruption. In more complex cases you may need to use higher innodb_force_recovery modes to block purging activity, insert buffer merge…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… page corrupted in insert buffer itself there seems to be no way to make Innodb avoid touching it. Even when we dropped all Innodb tables… for Innodb to have some additional recovery options for example for skipping over insert buffer or undo buffer. True this would leave some tables corrupted…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…to Oracle? HT: You are right, bugs that cause data corruption, crashes, or wrong query results get the highest priority. …- choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, …
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… MySQL with innodb_force_recovery=4 (SRV_FORCE_NO_IBUF_MERGE). So in my case probably Insert buffer merge was affecting corrupted page rather… dump potentially corrupted tables (in this particular corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb_force_recovery…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…insert_buffer_size – Used by MyISAM tables only to optimize bulk inserts (multiple value inserts). Really helps if you have really bulk inserts…corrupted on crash. delayed_insert_limit, delayed_insert_timeout, delayed_queue_size Delayed inserts…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…, but the only InnoDB corruption issues that I have ever seen has been while developing WaffleGrid, when we forgot the insert buffer merge code. I have seen way more replication corruption issues than InnoDB corruption ones. Looking at the other…
Comment: Innodb crash recovery update
May 23, 2007 By 3 Comments
… wrote in the previous post most likely it is Innodb bug because corruption was happening always for the same index in the… was OK and easily recoverable but this time crash corrupted page was touched by insert buffer merge process which made this crash terminal 
Comment: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
… assume though such connecting should have some limitations. How does Innodb “feel” about LSN which is much higher in the pages… might have some data in the insert buffer stored in main tablespace and as such could cause corruption if it was not empty…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…rows in tens of thousands tables) Innodb was better choice mainly because of…, each may allocate myisam_sort_buffer_size and MySQL could crash or …hidden corruption may later cause crashes wrong query results and further data corruption. … to be one insert at the time. Happily inserts in MyISAM are…
