…, reloading the data will be a very IO intense operation (redo logs, binlogs, etc) as well further polluting the buffer pool. Enter… tablespace files while streaming the redo-logs to ensure that all transactions are also captured. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace and…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…/ib_logfile1 Tue May 21 22:23:15 CDT 2013 Log sequence number 17750417191 Tue May 21 22:24:15 CDT 2013 Log sequence number 17750981011 -rw-rw—- 1 mysql mysql 536870912 May…-performance-recovery.html “If you kept the size of your redo log files artificially low because recovery took a long time, you…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… the transaction commits and that takes an fsync to the redo log by default, so applying Callaghan’s law to single-server… relax that by simply not fsyncing every transaction (innodb_flush_log_at_trx_commit != 1), or work around it with by… Innodb, you might consider relaxing the fsync: set innodb_flush_log_at_trx_commit to something besides 1 and suddenly you…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… the fact that this is using InnoDB under the hood (redo logs, etc). Based on the above numbers, here are the relative…
Post: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
… in the redo log What is not obvious from the documentation is that while Innodb_os_log_written is incremented when the log file…_os_log_written is the number of bytes written to the redo logs. But it does not reflect the growth of the redo logs. So when you are trying to size the redo logs, looking…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… 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…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… pages in memory and records page operations in the transaction (redo) log. Behind the scenes those updated (dirty) buffer pool pages are… database. Recovery uses the transaction log by redoing (hence the name ‘redo log‘) the page operations in the log that had not already been flushed… it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number 9682004056 Log flushed up to 9682004056 Last checkpoint at 9682002296 This…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… might accumulate and become much larger. What happens if the log buffer is actually smaller than a transaction? That’s another… my head. Is the distribution meaningful for determining the necessary log buffer size? The largest write above is just under 40k… distribution is a simple observation to make, but the InnoDB redo log system is intricate. It’s not something to guess about…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… redo log about the BLOB page writes, and only after that write the redo log about the B-tree changes. The buggy fix would log… redo log about the BLOB page writes, and only after that write the redo log about the B-tree changes. The buggy fix would log… record update. However, there is no redo log record for file extension in the current redo log format. rb:693 approved by Sunny Bains
Comment: Innodb Double Write
March 31, 2011 By 24 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… some changes to the disk. But when we apply redo log, we will redo the planned actions. For example, we have 4 blocks…
