Re: [Maria-developers] benchmarking next steps

2014-01-23 Thread MARK CALLAGHAN
This is good news. Don't forget to have someone write a blog post about it. On Tue, Jan 21, 2014 at 7:04 AM, Michael Widenius wrote: > > Hi! > > > "Sergey" == Sergey Vojtovich writes: > > Sergey> Hi Mark, > Sergey> we identified a few single-thread performance issues during the > Barcelona

Re: [Maria-developers] benchmarking next steps

2014-01-21 Thread Sergey Vojtovich
Hi Mark, thanks for this interesting reading. I will also want to have a look at how much MariaDB is affected by reported regressions and if there are easy ways to workaround them. Recently, when I ran single thread benchmarks I observed similar results, that is parser and optimizer were top CPU

Re: [Maria-developers] benchmarking next steps

2014-01-21 Thread Michael Widenius
Hi! > "Sergey" == Sergey Vojtovich writes: Sergey> Hi Mark, Sergey> we identified a few single-thread performance issues during the Barcelona Sergey> meeting. Monty should have them fixed in his private tree. Fixes are quite Sergey> generic and should improve performance almost in all cas

Re: [Maria-developers] benchmarking next steps

2014-01-20 Thread MARK CALLAGHAN
My analysis was based on benchmarks and described in a few blog posts. This is interesting for a few reasons. 1) replication is single-threaded at least for a few more years. Eventually we will all have the Kristian-inspired idea of getting parallel replication apply even when there is only one dat

Re: [Maria-developers] benchmarking next steps

2014-01-20 Thread MARK CALLAGHAN
I noticed the latest blog post from Kristian after posting my question. Haven't read all of it yet, but your work looks very good. Your blog posts are also a great way to get more visibility for MariaDB (on Facebook and elsewhere). On Mon, Jan 20, 2014 at 8:58 AM, Kristian Nielsen wrote: > MARK

Re: [Maria-developers] benchmarking next steps

2014-01-20 Thread Kristian Nielsen
MARK CALLAGHAN writes: > Are there other goals for single-thread performance regressions? There are > many that have nothing to do with replication code although almost every > single-threaded replication hurts replication. I am planning to do a general in-depth analysis of single-threaded perf

Re: [Maria-developers] benchmarking next steps

2014-01-20 Thread Sergey Vojtovich
Hi Mark, we identified a few single-thread performance issues during the Barcelona meeting. Monty should have them fixed in his private tree. Fixes are quite generic and should improve performance almost in all cases. An exception is bottlenecks specific to certain use cases. Could you send me an

Re: [Maria-developers] benchmarking next steps

2014-01-20 Thread MARK CALLAGHAN
Are there other goals for single-thread performance regressions? There are many that have nothing to do with replication code although almost every single-threaded replication hurts replication. On Mon, Jan 20, 2014 at 2:54 AM, Axel Schwenke wrote: > Hi, > > for those of you who didn't attend

[Maria-developers] benchmarking next steps

2014-01-20 Thread Axel Schwenke
Hi, for those of you who didn't attend the Barcelona meeting last week, here are the plans for next steps in benchmarking: 1. top priority is automatic running of DBT3 for each new release of MariaDB-10.0 and MySQL-5.6. Probably also for MariaDB-5.5. I'll send out another mail to pinpoint DBT3 co