…is you can actually start MySQL Server on it and perform recovery, check tables or do whatever else you…is consistent. Backing up database which was already corrupted is very nasty problem you want to avoid…long running queries. If you’re using only Innodb tables and do not need to synchronize binary …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… rows in tens of thousands tables) Innodb was better choice mainly because of thouse other behaviors … well table locks was the problem at…-checked tables fail with table does not exist error rather than wait forever. Hidden corruptions. If could be bad memory OS or MySQL bugs but corruption…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…” either as Innodb is very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb it will assert… auto check functions for your data partition and just check it manually as needed, same as you would every so often check MySQL tables for corruption…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… to be removed or overwritten A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or…, and RAID array does not recover You run into a InnoDB corruption bug that propagates via replication (not common, but does happen…_threshold should be set so if your nsca hasn’t checked in within a certain period it will alert you. For…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…amount of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve … HT: You are right, bugs that cause data corruption, crashes, or wrong query results get the highest… status or bug in implementation. I’ll check with Alexander or check myself to see what it could…
Post: Bug#12704861
November 20, 2011 By 1 Comment
…MySQL 5.1.60. I’ll repeat here the full documentation from the release notes: “InnoDB… were being updated in an InnoDB table. (Bug #12704861)” This wasn’t …, the index tree would be corrupted. The correct solution is to …leaves_validate(): A debug function for checking that all clustered index leaf …
Post: Innodb Double Write
August 4, 2006 By 24 Comments
…Innodb uses is technique called “doublewrite” It means Innodb will write data twice when it performs table…Innodb doublewirite was implemented I had couple of data corruptions…time. Now on recovery Innodb checks doublewrite buffer contents and…double write buffer affect MySQL Performance ? Even though …
Post: Small things are better
October 8, 2006 By 15 Comments
… hours especially as automatic check on boot failed and had to be manually restarted. Same may happen with Innodb tables. They are designed… corrupted because of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or failures. Sometimes corruption kind be mild, so ALTER TABLE to rebuild the table…
Post: xtrabackup-0.8
July 1, 2009 By 8 Comments
…InnoDB tables between servers”for details) tar4ibd is made to be sure that read of InnoDB page is consistent. Before we had some complains what in stream mode some pages are getting corrupted…after –prepare Data page corruption check is added to …://www.percona.com/mysql/xtrabackup/0.8/. The…
Post: Monty unviels Maria and starts Blogging
January 29, 2008 By 4 Comments
…partially executed statements or check and repair tables in case of …level locks functionally close to Innodb or Falcon. Though many …theory never is corrupted and database maintains consistency between tables so you…engine of choice for future MySQL. Again, Congratulations Monty, these are both…
