… prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied by the… all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs. Fixed by terminating xtrabackup process immediately on log copying…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
Post: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
… when the log buffer is written. This is interesting. It means that the durability setting can skew the results: if innodb_flush_log_at… when innodb_flush_log_at_trx_commit is set to 1 or 2 (again, thanks Alexey): Transaction 1 writes 100 bytes to the log buffer At commit, InnoDB writes a 512-byte block at offset xxx and increments Innodb_os_log_written by 512…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… your log file requires. Note depending on your innodb_flush_log_at_trx_commit value your log writes may be more or less expensive. If innodb_flush_logs_at_trx_commit=2 log writes…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…, which InnoDB configured for this hardware innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 1900M innodb_log_files…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… /* Write log buffer to log about once a second and flush */ innodb_flush_log_at_trx_commit = 1 /* Write log buffer to log and flush to disk */ innodb_flush_log_at_trx_commit = 2 /* Write log buffer to log and flush about…
Post: InnoDB Flushing: Theory and solutions
April 4, 2011 By 23 Comments
I mentioned problems with InnoDB flushing in a previous post. Before getting to ideas on a … a crash or system failure, InnoDB is logging changes into InnoDB transaction logs. The size of the InnoDB transaction log defines how many changed blocks we… age of the oldest modified non-flushed page. Checkpoint_age is located somewhere between 0 and innodb_log_file_size. Point 0 means…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… bound by the LRU list, then innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size do not matter, and… intensive writes, InnoDB is using LRU list flushing. So why is it important to know what the mix of InnoDB flushing types is in… 5.1/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size…
Post: Adaptive flushing in MySQL 5.6
September 4, 2012 By 8 Comments
… innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 2 innodb_buffer_pool_size = 150G innodb_log_file_size = 4G innodb_log_files…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty pages per flush. That means that under a heavy write load, a new flush… get good performance is to set innodb_flush_log_at_trx_commit=2, that is, to flush the log to the disk only once per… so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1, to implement XA, and…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… ~ 10GB of data, 12G innodb_buffer_pool_size, 1G innodb_log_file_size), MySQL 5.5.10 with innodb_adaptive_flushing=ON (default)). The problem… this (alas, 8 pages flushed). That is, instead of flushing 8 pages what we would expect to be flushed, InnoDB flushes 1 needed page and… why innodb_adaptive_flushing is not able to keep up. What if we disable flushing of neighbor pages (we have the option innodb_flush_neighbor…
