… 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… number of hard drives. So how do you estimate how long it takes Innodb to Recover ? Now you know there are multiple…
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… it to recover. Doing this several times you should be able to estimate how long recovery time take and adjust your logs apropriately. The…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…Innodb stops (read: crashes) with dirty buffer pool pages, Innodb recovery must be done to rebuild the last consistent picture of the database. Recovery…times before the page is flushed Multiple rows within the same page can be written before the page is flushed Innodb… be ‘estimate‘ (good default…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… adaptive flushing algorithm in InnoDB. In fact, we already have three such algorithms in Percona Server (reflex, estimate, keep_average). Why do… 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_size…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…disk based storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid, …to copy files. Fast Recovery Recovery time is as fast as putting data back and standard MySQL crash recovery, and it …hot backup, but bad thing it is hard to estimate when it is hot and when it is not …
Comment: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… allowable to change is innodb_log_file_size, as it will define balance between performance and recovery time. So setting innodb_log_file_size….. around 5-10 NOTPM > Then I’m curious: >– why XtraDB “estimate” mode was not ok here?.. We still fall into async… to test without O_DIRECT ?.. Nope > – did you test with innodb_flush_log_at_trx_commit=1 or other?.. Nope
