Hi, MARK!
On Dec 29, MARK CALLAGHAN wrote:
> On Tue, Dec 29, 2009 at 11:23 AM, Sergei Golubchik wrote:
>
> Is this a potential problem?
> * order of transactions in binlog don't commit record order for InnoDB
> in transaction log
> * binlog rotation occurs
> * last binlog has XIDs 1, 3, 5
> * cu
On Tue, Dec 29, 2009 at 11:23 AM, Sergei Golubchik wrote:
> Hi, Paul!
>
> On Dec 29, Paul McCullagh wrote:
>> On Dec 26, 2009, at 3:40 AM, MARK CALLAGHAN wrote:
>>
>>> * InnoDB locks prepare_commit_mutex in the prepare step
>>
>> What is the purpose of this lock?
>
> As far as I understand (discla
On Tue, Dec 29, 2009 at 11:07 AM, Sergei Golubchik wrote:
> Hi, MARK!
>
> On Dec 29, MARK CALLAGHAN wrote:
>> On Mon, Dec 28, 2009 at 9:20 AM, Sergei Golubchik wrote:
>> >
>> > trn1> start transaction; insert t1 select * from t2;
>> > trn1> commit;
>> > trn1>> ... xa_prepare() ...
>>
>> > trn
Hi, MARK!
On Dec 29, MARK CALLAGHAN wrote:
> On Mon, Dec 28, 2009 at 9:20 AM, Sergei Golubchik wrote:
> >
> > trn1> start transaction; insert t1 select * from t2;
> > trn1> commit;
> > trn1>> ... xa_prepare() ...
>
> > trn2> start transaction; insert t2 values (1); commit;
> > trn2>> xa_pre
Hi, Paul!
On Dec 29, Paul McCullagh wrote:
> On Dec 26, 2009, at 3:40 AM, MARK CALLAGHAN wrote:
>
>> * InnoDB locks prepare_commit_mutex in the prepare step
>
> What is the purpose of this lock?
As far as I understand (disclaimer!), it's purpose is to ensure that
commit records in the InnoDB tran
On Mon, Dec 28, 2009 at 9:20 AM, Sergei Golubchik wrote:
> Hi, MARK!
>
> On Dec 25, MARK CALLAGHAN wrote:
>>
>> InnoDB fixed group commit in the InnoDB plugin. This performs as
>> expected when the binlog is disabled. This does not perform as I
>> expect when the binlog is enabled.
>>
>> The probl
Hi Mark,
On Dec 26, 2009, at 3:40 AM, MARK CALLAGHAN wrote:
InnoDB fixed group commit in the InnoDB plugin. This performs as
expected when the binlog is disabled. This does not perform as I
expect when the binlog is enabled.
Is this a problem for PBXT?
PBXT is also affected by the lack of gr
Hi, MARK!
On Dec 25, MARK CALLAGHAN wrote:
>
> InnoDB fixed group commit in the InnoDB plugin. This performs as
> expected when the binlog is disabled. This does not perform as I
> expect when the binlog is enabled.
>
> The problems for InnoDB are:
> 1) commit is serialized on the binlog write/f
InnoDB fixed group commit in the InnoDB plugin. This performs as
expected when the binlog is disabled. This does not perform as I
expect when the binlog is enabled.
Is this a problem for PBXT?
The problems for InnoDB are:
1) commit is serialized on the binlog write/fsync
2) row locks are not rele
9 matches
Mail list logo
