Stay Curious!

What do the InnoDB insert buffer statistics mean?

Ever seen this in SHOW INNODB STATUS and wondered what it means?

-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 4634, seg size 4636,

I’ve never been quite sure, and Peter didn’t really clarify things himself, so I took a look at the source. If I’m not mistaken, the seg size is really one more than the number of records the insert buffer can hold, the free list length is the number that aren’t in use, and the size is just seg_size - (1 + free_list_len). These seem to be kept in lockstep as records are inserted and merged.

Posted on Sun, Oct 25, 2009. Approximately 200 Words.

Databases