… affects both response time and throughput – The transaction log. The InnoDB transaction log handles REDO logging, this is the mechanism that provides the A (Atomic) C (Consistent)Â and D (Durability) in ACID. The transaction log…
Comment: Innodb Double Write
March 31, 2011 By 23 Comments
… in the log should be redo when doing recovery? I think even the page is “partial written”, it doesn’t matter, redo log know… the redo log. Unless you mean “partial write” will modify someting not saved in the redo log?? I mean, EVERY change are in the redo log… the disk is consistent or not, this is what redo in theory to handle, isn’t it? So I think I still…
Comment: Innodb Double Write
August 4, 2006 By 23 Comments
… in the log should be redo when doing recovery? I think even the page is “partial written”, it doesn’t matter, redo log know… the redo log. Unless you mean “partial write” will modify someting not saved in the redo log?? I mean, EVERY change are in the redo log… the disk is consistent or not, this is what redo in theory to handle, isn’t it? So I think I still…
Comment: How InnoDB handles REDO logging
April 20, 2011 By 18 Comments
… undo and redo log in innodb. In InnoDB UNDO logging is handled via the UNDO log (Also referred to as the ROLLBACK segment). UNDO logging being the inverse of REDO, used in…. >one possibility is don’t flush dirty pages until related redo-logs are flushed, but it looks only >allowing one transaction per…
Comment: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
… undo and redo log in innodb. In InnoDB UNDO logging is handled via the UNDO log (Also referred to as the ROLLBACK segment). UNDO logging being the inverse of REDO, used in…. >one possibility is don’t flush dirty pages until related redo-logs are flushed, but it looks only >allowing one transaction per…
Post: MVCC: Transaction IDs, Log Sequence numbers and Snapshots
December 19, 2007 By 3 Comments
… kill it in case of deadlock, for proper isolation mode handling – transaction should see its own uncommitted changes but other transactions… can roll back or redo changes for transaction depending if it was committed or not. Log Sequence Number (LSN) Log Sequence Numbers correspond… current transaction was started. This is needed for example to handle READ-COMMITTED isolation mode. Lets look at transaction 102 which…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… matching log records in the log file (which is circular). Size of log records While we speak about log file … time even more I hope Heikki will enable redo and undo phases to be performed in the parallel… benchmarks – apply the load you expect system to handle and crash Innodb few times to see how …
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 20 Comments
… to have compile in debug mode, I am redoing the benchmarks. Updated version here. I recently had… innodb_buffer_pool_size=1G innodb_log_file_size=64M innodb_log_buffer_size=8M innodb_flush_method… laptop (running dbt2) was not slowed down by handling all those connections. I tried generating the idle…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
… ib_logfile* when innobackupex is called with –redo-only or with –incremental-dir. If neccessary …Gostev) Bug #597384 – The innobackup –include option now handles non-InnoDB tables. (Vadim Tkachenko) Bug #606981 -…innobackupex. (Baron Schwartz) Bug #672384 – When no log files can be found in the …
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… very large log files… Innodb uses the same process as during recovery which is optimized for handling relatively small number of redo records.
