Skip site navigation (1) Skip section navigation (2)

Re: Probable faq: need some benchmarks of pgsql vr.s mysql

From: MARK CALLAGHAN <mdcallag(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Probable faq: need some benchmarks of pgsql vr.s mysql
Date: 2010-11-17 20:24:01
Message-ID: AANLkTiknpQm2Zhhvkk1PY054QkDoa5NV=Q_j1riQQy-P@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-advocacy
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

In response to

Responses

pgsql-advocacy by date

Next:From: Josh BerkusDate: 2010-11-17 23:52:07
Subject: Re: Probable faq: need some benchmarks of pgsql vr.s mysql
Previous:From: Dan LangilleDate: 2010-11-12 02:56:40
Subject: PGCon 2011 - dates (corrected)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group