…MySQL database configuration follows this active/passive pattern. There is a virtual IP that points to the active server of a…pages were loaded from disk. Replaying Queries Working with Groupon, we have developed a…corrupting the data on…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… or some rare MySQL bug and some pages 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 read of page 7. InnoDB: You may have to recover from a backup. 080703 23:46:16 InnoDB: Page dump…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…corrupted…disk at least up to this lsn” (log serial number), valid only on the first page of the file FIL_PAGE_ARCH_LOG_NO_OR…page. How let’s connect actor.ibd from sakila database taken from some MySQL…
Post: Monty unviels Maria and starts Blogging
January 29, 2008 By 4 Comments
…MyISAM – it has page cache for rows… performance for certain on disk temporary tables (both…theory never is corrupted and database maintains … give it a try on your workload…fail and never deliver its promises (so there is backup) or turn not to be transactional storage engine of choice for future MySQL…
