…how can you check what error behavior mode your file system has ? Run dumpe2fs /dev/sda1 and you will get…Innodb is very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb…as you would every so often check MySQL tables for corruption. To change those options …
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 …right, bugs that cause data corruption, crashes, or wrong query results get the highest priority. We are… group? HT: InnoDB writes the checkpoint information to the first file. Q31: How often or what is …
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
…MySQL server. If you try to very often you’ll get an error in the log: InnoDB…How let’s connect actor.ibd from sakila database taken from some MySQL server. 0. Create empty InnoDB tablespace. 1. Create the table: mysql>CREATE TABLE…
Post: Add an option to Fail on Innodb Initialize failure, Please ?
October 11, 2007 By 9 Comments
…MySQL 5.0 introduces STRICT option which will makes error control more strict, what is often…MySQL server Error Logs but the error message accessing Innodb tables is also very obfuscated: error : Incorrect information in file: ‘./prod/user.frm’ How…is corrupted, and indeed you still can get this error…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… magically means nobody knows how exactly. I would … is about MySQL/Innodb specifics ? First, in MySQL if you’re…be serialized. Second, MySQL is often not able to …the time if Innodb or MyISAM tables are used. …causing failure and data corruption (and this is not … the storage but you get 2 copies of …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…MySQL crash recovery, and it can be reduced even further. More on this later. Free No extra commercial tools as Innodb…often hot backup, but bad thing it is hard to estimate when it is hot and when it is not – FLUSH TABLES…bit about how LVM …was already corrupted is very…snapshot will get invalidated …
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…MySQL. Yet another way is using DRBD to get a standby MySQL…be things like Innodb corruption or soft …or several small tables corrupted you can … with (which often can be …MySQL bugs or wrong use. Interesting enough very few people have their data recovery practices ironed out so they can answer how…
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
…InnoDB‘s point of view, though, it was still completely corrupted. The “InnoDB… ext2 does not know how to do that. … such a disaster: 1) get qualified advice and 2)… point that I repeat often. The danger of using…MySQL slave for a “backup,” you’ll be out of luck when someone accidentally runs DROP TABLE…
Post: Monty unviels Maria and starts Blogging
January 29, 2008 By 4 Comments
…Innodb or Falcon. Though many internal architecture decisions are different from either. What I also like about Maria is – it gets…corrupted and database maintains consistency between tables so you should not be moving them around in binary format but it is often…
