…). When option innodb_flush_method=O_DIRECT was set up, log bitmap files were created and treated as InnoDB data files for flushing purposes, which wasn’t original intention. Bug fixed #1105709 (Laurynas Biveinis). INFORMATION_SCHEMA plugin name innodb_changed… page, except the first one, would result in a heap corruption. Bug fixed #1111226 (Laurynas Biveinis). Fixed the upstream bug #67504…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… which are very latency critical. Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable… queries executed having only one IO at the time if Innodb or MyISAM tables are used. There is read-ahead functionality… redundant the Firmware may have a glitch causing failure and data corruption (and this is not just a speculation, some clients really…
Comment: Verifying backup integrity with CHECK TABLES
February 1, 2012 By 4 Comments
… LVM). The use of Xtrabackup or InnoDB Hot Backup is based on software which reads the InnoDB data. Thus, it is in itself part of the system, and is susceptible to such corruptions. A file system snapshot is blind to internal issues, and blindly reflects your data.
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… based standby 2) Data corruption with crash. Switch to the slave. 3) Hacker break in or developer trashes the data – switch to time… instantly available if you need to roll back to old data copy. Also – with $5000 cost per minute you could pay… very possible we would have recommended you to stay with Innodb reviewing your application. Just recognize it is not typical. Working…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
May 22, 2007 By 117 Comments
… Java developer). I set all thread-related numbers on MySQL InnoDB to high numbers; I/O threads = 512… Client application is… box. I’ll try to perform 1-week crawl with InnoDB, 1-week crawl with SolidDB, and compare results (total number… crawled pages). I had a problem with Oracle 10g, daily data corruption (Seagate Barracuda, probably overheated). After moving to Cheetah 15K.5…
Comment: MySQL opening .frm even when table is in table definition cache
November 23, 2011 By 8 Comments
this will depend on the storage engine of course.. for file based ones such as MyISAM this is certainly true. But for certain types of InnoDB data dictionary corruption, it could be more of a problem.
Comment: MySQL performance on EC2/EBS versus RDS
August 27, 2011 By 11 Comments
BTW, I have seen data corruption on EBS volumes. It’s not clear whether it was InnoDB‘s fault (extremely unlikely IMO), the…
Comment: RAID vs SSD vs FusionIO
May 4, 2009 By 17 Comments
To be honest these benchmarks are somewhat pointless. Who would run a database without durability? It’s better to run innodb flush tx at log commit=2 rather than have the disk subsystem do this. You can lose some transactions but at least when you restart you don’t have data corruption.
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… number of Innodb tables you have, as well as many other operations, so beware. Binary log corruption – Binary log may become corrupted and… you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write about them…
Post: Verifying backup integrity with CHECK TABLES
February 1, 2012 By 4 Comments
… InnoDB‘s handling of corrupted pages, because the best way to check for corruption is with CHECK TABLES, but if a page is corrupt, InnoDB will crash the server to prevent access to the corrupt data. As mentioned in that post, this can only be changed by changing InnoDB. So how are you supposed to check for corruption…
