Re: [Maria-developers] commit performance when the binlog is enabled

2009-12-29 Thread MARK CALLAGHAN
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

Re: [Maria-developers] commit performance when the binlog is enabled

2009-12-29 Thread MARK CALLAGHAN
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

Re: [Maria-developers] Rev 4: Added wrapper scripts for automated runs of sql-bench

2009-12-29 Thread Sergei Golubchik
Hi, Hakan! On Dec 29, Hakan Kuecuekyilmaz wrote: > At file:///Users/hakan/work/monty_program/mariadb-tools/ > > > revno: 4 > revision-id: ha...@askmonty.org-20091229134253-zdbgd0ym9m7cokii > parent: kniel...@knielsen-hq.org-200912181035

Re: [Maria-developers] commit performance when the binlog is enabled

2009-12-29 Thread Sergei Golubchik
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

Re: [Maria-developers] commit performance when the binlog is enabled

2009-12-29 Thread Sergei Golubchik
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

Re: [Maria-developers] commit performance when the binlog is enabled

2009-12-29 Thread MARK CALLAGHAN
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

[Maria-developers] Rev 4: Added wrapper scripts for automated runs of sql-bench. in file:///Users/hakan/work/monty_program/mariadb-tools/

2009-12-29 Thread Hakan Kuecuekyilmaz
At file:///Users/hakan/work/monty_program/mariadb-tools/ revno: 4 revision-id: ha...@askmonty.org-20091229134253-zdbgd0ym9m7cokii parent: kniel...@knielsen-hq.org-20091218103524-nof6wfpuku60r9rn committer: Hakan Kuecuekyilmaz branch nic

Re: [Maria-developers] 2PC between two engines + binlog

2009-12-29 Thread Kristian Nielsen
Paul McCullagh writes: > All tests look good, so I have proposed the bug fix mentioned below > for merging: > > lp:~paul-mccullagh/maria/maria-pbxt-1009g Thanks! I have merged this into the MariaDB 5.1.41 release clone (will later also be merged into main lp:maria). - Kristian. __

Re: [Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (monty:2786)

2009-12-29 Thread Kristian Nielsen
Michael Widenius writes: > === modified file 'mysql-test/t/ctype_utf8.test' > --- a/mysql-test/t/ctype_utf8.test2009-01-26 21:19:13 + > +++ b/mysql-test/t/ctype_utf8.test2009-12-27 13:54:41 + > @@ -2,6 +2,15 @@ > # Tests with the utf8 character set > # > > +let collation=utf8_

[Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2783)

2009-12-29 Thread knielsen
#At lp:maria 2783 kniel...@knielsen-hq.org 2009-12-29 [merge] Merge PBXT fix from Paul. modified: storage/pbxt/ChangeLog storage/pbxt/src/discover_xt.cc storage/pbxt/src/ha_pbxt.cc storage/pbxt/src/strutil_xt.cc === modified file 'storage/pbxt/ChangeL

[Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2782)

2009-12-29 Thread knielsen
#At lp:maria 2782 kniel...@knielsen-hq.org 2009-12-29 [merge] Merge Sergey's fix for pbxt.join_nested. modified: mysql-test/suite/pbxt/r/join_nested.result mysql-test/suite/pbxt/t/join_nested.test === modified file 'mysql-test/suite/pbxt/r/join_nested.result' --- a/m

Re: [Maria-developers] 2PC between two engines + binlog

2009-12-29 Thread Paul McCullagh
Hi Hakan, All tests look good, so I have proposed the bug fix mentioned below for merging: lp:~paul-mccullagh/maria/maria-pbxt-1009g On Dec 21, 2009, at 3:09 PM, Hakan Kuecuekyilmaz wrote: Hi Paul, I will wait for your update. Cheers, Hakan On 21.12.2009, at 14:21, Paul McCullagh wrote

Re: [Maria-developers] commit performance when the binlog is enabled

2009-12-29 Thread Paul McCullagh
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