… their former state. Most typically partial page writes happen when power failure happens. It also can happen on OS crash – there is… requiring multiple IO requests. Same happens with Hardware RAID on power failure if it does not have battery backed up cache. If… term log file allocated inside Innodb tablespace – it contains space for 100 pages. When Innodb flushes pages from Innodb buffer pool it does…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…’re running MySQL with Innodb tables and you’ve got crappy hardware, driver bug, kernel bug, unlucky power failure or some rare MySQL bug and some pages in Innodb tablespace got corrupted. In such cases Innodb will typically print….mysql.com. InnoDB: If you get repeated assertion failures or crashes, even If you get such assertion failures most likely higher innodb_force_recovery…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… you’re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance… increase recovery time, so in case of MySQL crash or power failure it may take long time before MySQL Server is operational… on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find…
Post: Small things are better
October 8, 2006 By 15 Comments
… not need checks in normal use, even in case of power failures. Checking and repairing took many hours especially as automatic check… manually restarted. Same may happen with Innodb tables. They are designed to never crash, surviving power failures and even partial page writes but… of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or failures. Sometimes corruption kind be mild, so ALTER TABLE to rebuild…
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
… lost on power failure. Happily most of these are resolved now with “real hardware” and I’m pretty confident running Innodb with both default (fsync based) or O_DIRECT innodb_flush_method. Virtualization however adds yet…’re relying on system to be able to recover from power failure or VM crash make sure to test it carefully.
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… application (storing billions of rows in tens of thousands tables) Innodb was better choice mainly because of thouse other behaviors … well… tables. I still have the same view on Storage Engines – Innodb is my oppinion is better choise for general purpose storage… sense of security but when it crashed (or was it power failure?) It took many hours to check recover our tables. If…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional…” looks a bit scary here but again potential fsck on power failure is probably not the problem for benchmark specs. But what…
Post: MySQL should have dynamic durability settings
April 8, 2008 By 4 Comments
If you’re using Innodb tables MySQL has innodb_flush_log_at_trx_commit variable which defines how durable … not lost) but does not save from OS crashes or power failures. So far so good. The only problem is many applications… picky about product rating votes. What Innodb could do is at least to make innodb_flush_log_at_trx_commit a session…
Comment: Should you move from MyISAM to Innodb ?
December 20, 2012 By 59 Comments
I am afraid of Innodb corruption since from time to time the computer goes offline (due power failure or other reasons). I’ve read that it sucks when Innodb get corrupted, while MyISAM tables can be repaired with REPAIR table .
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… MyISAM they will lock tables for very long time and Innodb can get too many old row versions to deal with… after power failure as check and repair may take long hours (this is indeed one of the big reasons to use Innodb even…
