Re: Probable faq: need some benchmarks of pgsql vr.s mysql - Mailing list pgsql-advocacy

From MARK CALLAGHAN
Subject Re: Probable faq: need some benchmarks of pgsql vr.s mysql
Date
Msg-id AANLkTiknpQm2Zhhvkk1PY054QkDoa5NV=Q_j1riQQy-P@mail.gmail.com
Whole thread Raw
In response to Re: Probable faq: need some benchmarks of pgsql vr.s mysql  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Probable faq: need some benchmarks of pgsql vr.s mysql
List pgsql-advocacy
On Mon, Nov 8, 2010 at 10:02 AM, Josh Berkus <josh@agliodbs.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@gmail.com

pgsql-advocacy by date:

Previous
From: Dan Langille
Date:
Subject: PGCon 2011 - dates (corrected)
Next
From: Josh Berkus
Date:
Subject: Re: Probable faq: need some benchmarks of pgsql vr.s mysql