… innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb…=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… tablespaces, separate undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading… prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied by the…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… tablespaces, separate undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading… prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied by the…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 368, undo log entries 1 MySQL… will also grow and innodb_max_purge_lag will become your friend. “undo n:o” will show the undo log record number which purge… Log section provides information about log subsystem of Innodb. You can see current log sequence number – which is amount of bytes Innodb has written in log…
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 been applied in memory and do not exist in tablespace. Log records… other important one is undo phase – after log file are applied and database is in “physically consistent” state, Innodb will need to roll…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… (as I recall). When InnoDB loads the file, it creates one big transaction with a lot of undo log entries. This has a… make InnoDB behave like PostgreSQL 
If the undo log space grows really big, it won’t fit in the buffer pool and InnoDB essentially… the undo log entries being written to disk. (Peter arrived at the same guess independently.) Unfortunately I didn’t think to log the…
Comment: How InnoDB handles REDO logging
April 20, 2011 By 19 Comments
… the relationship between 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 the case of InnoDB to…
Comment: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… the relationship between 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 the case of InnoDB to…
Post: Announcing Percona Server 5.5.27-28.0
August 23, 2012 By 5 Comments
… variables. New table INNODB_UNDO_LOGS has been added to allow access to undo segment information. Each row represents an individual undo segment and contains… value of innodb_autoinc_lock_mode=1. Bug fixed #1035225 (Alexey Kopytov). Removed error log warnings that occured after enabling innodb_use_sys…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… */ 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… 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…
