… handled via the UNDO log (Also referred to as the ROLLBACK segment). UNDO logging being the inverse of REDO, used in the… InnoDB to both support MVCC and provide a mechanism to rollback uncommitted transactions during recovery. >How does innodb keep the consistent…
Comment: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… handled via the UNDO log (Also referred to as the ROLLBACK segment). UNDO logging being the inverse of REDO, used in the… InnoDB to both support MVCC and provide a mechanism to rollback uncommitted transactions during recovery. >How does innodb keep the consistent…
Post: Percona Server 5.5.11-20.2 Stable Release
April 28, 2011 By 1 Comment
… Variable innodb_extra_rsegments was removed because the equivalent, ‘innodb_rollback_segments’, has been implemented in MySQL 5.5. (Yasufumi Kinoshita) Bug…
Post: Recover BLOB fields
July 1, 2010 By 4 Comments
… a transaction id. PTR_ID is a pointer in a rollback segment to the old version of the record. So if a…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… Improved buffer_pool scalability Fast recovery Improved IO path Improved rollback segment scalability Separate purge thread Limited size of data dictionary in…
Comment: MySQL 5.5-m2 scalability
March 1, 2010 By 17 Comments
Andy, This is topic for another blog post. As I mention current bottleneck I see is rollback segment, and we have patch for this, so absolute results in XtraDB is better, but performance drop with many threads is still in place.
Comment: Index lock and adaptive search - next two biggest InnoDB problems
March 1, 2010 By 12 Comments
… named index->lock and adaptive_search lock, there is single rollback segment and single lock on intrenal data dictionary. It is not…
Comment: MySQL 5.5-m2 scalability
February 28, 2010 By 17 Comments
Once we fixed a few other problems we have begun to notice dogpiles on our servers from contention on the rollback segment mutex. I am glad you noticed this first.
Post: MySQL 5.5-m2 scalability
February 28, 2010 By 17 Comments
… 16 threads, that in current benchmarks – this is concurrency on rollback segment (which is global shared structure in InnoDB) sysbench command for…
Comment: Tuning for heavy writing workloads
October 15, 2009 By 9 Comments
…/datafile should be recreated to be able to use several rollback segments? (setting the option is not enough?) – from your TPS graph…
