Innodb - blogs.innodb.com - Transactions on InnoDB
General Information:
Latest News:
Redo Logging in InnoDB 15 Jul 2013 | 11:47 am
Introduction InnoDB is a general-purpose storage engine that balances high reliability and high performance. It is a transactional storage engine and is fully ACID compliant, as would be expected fro...
Introduction to Transaction Locks in InnoDB Storage Engine 31 May 2013 | 05:09 pm
Introduction Transaction locks are an important feature of any transactional storage engine. There are two types of transaction locks – table locks and row locks. Table locks are used to avoid a tabl...
Data Organization in InnoDB 19 Apr 2013 | 12:12 pm
Introduction This article will explain how the data is organized in InnoDB storage engine. First we will look at the various files that are created by InnoDB, then we look at the logical data organiz...
Repeatable Read Isolation Level in InnoDB - How Consistent Read View Works 15 Jan 2013 | 03:32 pm
This article discusses about the approach taken by InnoDB Storage Engine of MySQL to provide the repeatable read isolation level. First, an example is presented to demonstrate the two different desig...
Online ALTER TABLE in MySQL 5.6 29 Sep 2012 | 09:01 pm
This is the low-level view of data dictionary language (DDL) operations in the InnoDB storage engine in MySQL 5.6. John Russell gave a more high-level view in his blog post April 2012 Labs Release – O...
New Enhancements for InnoDB Memcached 29 Sep 2012 | 09:00 pm
In MySQL 5.6, we continued our development on InnoDB Memcached and completed a few widely desirable features that make InnoDB Memcached a competitive feature in more scenario. Notablely, they are 1) ...
Helping to Reduce Page Compression Failures Rate 29 Sep 2012 | 09:00 pm
When InnoDB compresses a page it needs the result to fit into its predetermined compressed page size (specified with KEY_BLOCK_SIZE). When the result does not fit we call that a compression failure. I...
InnoDB Compression Improvements in MySQL 5.6 29 Sep 2012 | 09:00 pm
MySQL 5.6 comes with significant improvements for the compression support inside InnoDB. The enhancements that we'll talk about in this piece are also a good example of community contributions. The wo...
Performance Enhancement in Full-Text Search Query 29 Sep 2012 | 09:00 pm
Ever since its first release, we are continuing consolidating and developing InnoDB Full-Text Search feature. There is one recent improvement that worth blogging about. It is an effort with MySQL Opti...
The New "Transactions on InnoDB" 15 Sep 2012 | 09:00 am
New home of the InnoDB team blog.
