… is faster to recover single tables than a full backup. This is easy with MyISAM but if your tables are InnoDB the… the use of –export option runs a recovery process on the backup with innodb_fast_shutdown=0 and therefore merging all the… the next blog post I’ll explain how to do recovery using Percona Data Recovery toolkit.
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 38 Comments
… to be big enough to let InnoDB optimize its I/O, but not so big that recovery takes a long time.Â… set to ‘grep sequence’ mysql> show engine innodb status\G select sleep(60); show engine innodb status\G Log sequence number 84 3836410803 1… into a given log file size, which will generally make recovery faster than you might expect with a big log. However, most…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… 2.5″ SAS hard drives. They are tiny but often faster than bigger ones. RAID10 works well for data storage and… out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed needs but 256M seems to be a good balance between reasonable recovery time and good performance innodb_log_buffer…
Post: Adjusting Innodb for Memory resident workload
March 25, 2009 By 11 Comments
… preload all innodb tables (ibdata, .ibd files) on the system start – this would avoid warmup problem and also make crash recovery fast even with very large log file – random IO is what usually limits recovery speed. Because files…. It should be possible to just size Innodb logs so they are not cycled through faster than flush cycle. This may not…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… it currently does which can be multiple orders of magnitude faster for large tables. There is fair number of questions about… there are more things inside Innodb to unleash performance such as multiple purge threads or parallel log recovery features, which he however needs to test properly before really enabling it. Innodb IO Tuning I should…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… from a snapshot (and binary logs for point in time recovery) in case of that ‘Oops’ moment? Let me show you… repositories i.e. updates on CentOS. If you are using InnoDB, it is also important that your transaction logs (ib_logfile… same logical volume, if not, you could potentially trigger crash recovery when an LSN mismatch occurs and still end up with…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… with all pages in buffer pool it well may be faster to do 1 write than flush 10 non sequential pages…. MySQL’s binlog and InnoDB‘s log must have the transactions in the same order, for a recovery based on MySQL’s binlog to work. Of course, if you remove that mutex from 5.1, then InnoDB‘s…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… memory at a faster rate than it can write to disks. Eventually it gets into an “async” state, where InnoDB tries to… be to increase innodb_log_file_size, but that: 1) only delays the problem until later; 2) increases recovery time (and that is an important factor with slow disks); and 3) MySQL does not support innodb_log_file…
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
… crash recovery performance over last couple of years and here we go again. It would be great to get an Innodb a… such tables (thankfully you can change this variable online in Innodb Plugin, MySQL 5.5 and Percona Server). Yes. if you… buffer pool size. MyISAM tables creating/dropping was several times faster still.
Post: Small things are better
October 8, 2006 By 15 Comments
… and had to be manually restarted. Same may happen with Innodb tables. They are designed to never crash, surviving power failures… time to restore, especially if you do point in time recovery using binary log to get to actual database state. The… end commodity hardware) makes it faster to recover, smaller tables allow per table backup and recovery to happen faster. With MySQL and blocking…
