Re: [Maria-developers] Benchmark of connect performance

2013-03-22 Thread Axel Schwenke
Hi, here comes another followup. After having seen huge impact from performance schema and the memory allocator, I started another run with optimal settings and a reduced number of contestants. Montys working tree 10.0-monty was added, that contains the latest optimizations. The benchmark uses a

Re: [Maria-developers] Benchmark of connect performance

2013-03-20 Thread Axel Schwenke
Axel Schwenke wrote: > http://yoshinorimatsunobu.blogspot.fi/2012/12/non-persistent-connection-performance.html > My results don't match Yoshis otherwise. See yourself. OK, I found what makes the difference between Yoshis results and mine. It's the performance schema. It defaults to being enabled

Re: [Maria-developers] Benchmark of connect performance

2013-03-19 Thread Axel Schwenke
Vladislav Vaintroub wrote: > > Historical remark on this, the patch for MDEV-3945, > This patch was inspired by the said Yoshi's blog entry - he > names holding lock during THD destructor (including freeing memory) as one > of contention sources, and this was easy to fix. This patch made into

Re: [Maria-developers] Benchmark of connect performance

2013-03-19 Thread Vladislav Vaintroub
ius; maria-developers@lists.launchpad.net > Subject: [Maria-developers] Benchmark of connect performance > > Hi, > > in the light of > http://yoshinorimatsunobu.blogspot.fi/2012/12/non-persistent-connection- > performance.html > The results don't match Yoshis otherw

Re: [Maria-developers] Benchmark of connect performance

2013-03-19 Thread MARK CALLAGHAN
This is great content for a blog post On Tue, Mar 19, 2013 at 7:51 AM, Axel Schwenke wrote: > Axel Schwenke wrote: > > > I did a similar benchmark. > > I have pushed the scripts and raw results to the mariadb-benchmarks repo. > There are results for different engines. > > mariadb-benchmarks/sys

Re: [Maria-developers] Benchmark of connect performance

2013-03-19 Thread Axel Schwenke
Axel Schwenke wrote: > I did a similar benchmark. I have pushed the scripts and raw results to the mariadb-benchmarks repo. There are results for different engines. mariadb-benchmarks/sysbench-runs/series22 = MyISAM mariadb-benchmarks/sysbench-runs/series23 = InnoDB (my previous mail) mariadb-be

[Maria-developers] Benchmark of connect performance

2013-03-19 Thread Axel Schwenke
Hi, in the light of http://yoshinorimatsunobu.blogspot.fi/2012/12/non-persistent-connection-performance.html I did a similar benchmark. I used sysbench-0.4.12 for this with this command line $SYSBENCH --test=oltp --oltp-table-size=1000 --oltp-dist-type=uniform --num-threads=$thread --oltp-read-o