…. Percona Server with XtraDB allows you to control the transaction log record size, as better performance may be gained with 4096 byte… be logged and then later rolled back do to an error or a specific request, as part of the DO-UNDO-REDO protocol InnoDB also records UNDO information, however that is stored outside of the transaction log and as such is…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find log records which only have…. Unlike “redo” phase “undo” phase can’t be reduced by sizing your log files. Even more undo phase can be slower with small log files. Undo phase…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… if logs are of reasonable size and wikipedia has 40 minutes or so with innodb_log_file_size=256MB. In other cases I know same log… by size of log files as Innodb needs to flush database pages to the tablespace before it can overwrite matching log records in the log… increase recovery time even more I hope Heikki will enable redo and undo phases to be performed in the parallel, which should…
Post: What is the longest part of Innodb Recovery Process ?
December 20, 2007 By 2 Comments
… above the longest part of recovery after crash for Innodb tables could be UNDO stage – it was happening in foreground and was… could take long hours. REDO stage on other hand always could be regulated by size of your Innodb log files so you could have… one. The server had about 65000 tables using innodb_file_per_table so “InnoDB: Reading tablespace information from the .ibd files…” stage…
Comment: How to estimate time it takes Innodb to Recover ?
December 20, 2007 By 7 Comments
… above the longest part of recovery after crash for Innodb tables could be UNDO stage – it was happening in foreground and was… could take long hours. REDO stage on other hand always could be regulated by size of your Innodb log files so you could have…
