… by AFTAB, crash recovery is far cheaper in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And…/en/innodb-performance-recovery.html “If you kept the size of your redo log files artificially low because recovery took a long time, you…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… pool. Note that this can be somewhat mitigated using innodb_old_blocks_time, but that is outside the scope of this post…. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace and… target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… be more zealous. Pretty interesting to speed up point in time recovery when you dataset is 700GB. If you google a bit… many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… is because virtual machines tend to handle process scheduling and timing much differently than traditional hardware, and I’ve seen situations… which are no longer complete or useful for point-in-time recovery. Generally if you’re considering the binary log filtering approach… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see: http://bugs.mysql.com/bug.php?id=29847 http://dammit.lt/2008/10/26/innodb-crash-recovery/ This is problem when your InnoDB crashes, it may takes long time to start. Also it…
Post: Innodb Recovery - Is large buffer pool always better ?
July 17, 2007 By 3 Comments
… Innodb crash recovery on box with large amount of memory (64GB) with Innodb Buffer pool configured to be just a bit over 20GB. Innodb recovery was taking long hours with reasonably sized Innodb log files… pages in the flush list which takes a lot of time… Innodb is smart about a way it flushes pages, it tries…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… innodb_force_recovery=4. So I decided to check if I’m to get lucky second time today. And Indeed Restarting Innodb with innodb_force_recovery…”. So when dealing with Innodb recovery for bad corruptions you may want to: – Start with lower innodb_force_recovery settings and see which one…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… log file time may have recovery time of 5-10 minutes. To understand things affecting recovery time you better to understand how Innodb recovery works. When Innodb recovers from logs it finds the last checkpoint time. Innodb has fuzzy…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… the problems. As I already wrote innodb_log_file_size and innodb_buffer_pool_size affect recovery time significantly as well as your workload. I should also mention if you have innodb_file_per_table=1 your recovery speed…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it too large will increase recovery time, so in case of MySQL crash or power failure it may take long time before MySQL Server… it to recover. Doing this several times you should be able to estimate how long recovery time take and adjust your logs apropriately…
