On Mon, Nov 8, 2010 at 10:02 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>
>
> How does InnoDB make sure that sessions see the buffered inserts if they
> should transactionally be visible?
There is an IO completion callback that is called when the read into
the buffer pool is finished. AFAIK, the callback will merge the
pending changes from the insert buffer. Oh, and the name of the insert
buffer has been changed to "change buffer" as it can buffer inserts
and deletes in MySQL 5.5. Also note that there are no updates for
secondary indexes. There is only insert and delete marking.
--
Mark Callaghan
mdcallag(at)gmail(dot)com