All posts by Annamalai Gurusami

About Annamalai Gurusami

MySQL InnoDB Storage Engine Developer (மையெசுக்கியூயெல் தரவுத்தள பொறியாளர்)

The InnoDB Change Buffer

One of the challenges in storage engine design is random I/O during a write operation. In InnoDB, a table will have one clustered index and zero or more secondary indexes.  Each of these indexes is a B-tree.  When a record is inserted into a table, the record is first inserted into clustered index and then into each of the secondary indexes. …