Re: [Maria-developers] MDEV-8356 analysis and ideas

2015-06-29 Thread Sergey Petrunia
Hi Diwas, Nice analysis. Please find my comments below. On Mon, Jun 29, 2015 at 10:01:56AM +0530, Diwas Joshi wrote: hello sergey, so i was reading further on MDEV-8356 last night. There are two main things here: type of sf and return type of sf. Right now the create function... is giving

Re: [Maria-developers] MariaDB multi-source replication testing at Booking.com

2015-06-29 Thread Kristian Nielsen
Karoly Nagy karoly.n...@booking.com writes: We're seeing very high and fluctuating mutex contentions while replicating from two sources (Oracle MySQL 5.6) to a single MariaDB slave. You can see that on the graphs below. The spin waits are relatively [1] aligned but the mutex rounds [2] are

[Maria-developers] Buildbot branch 10.0-custombld

2015-06-29 Thread Kristian Nielsen
Hi Rasmus, The branch 10.0-custombld seems to no longer build binaries (after the transition to git?): https://github.com/MariaDB/server/tree/10.0-custombld https://buildbot.askmonty.org/buildbot/grid?branch=10.0-custombldcategory=main Can you please fix Buildbot so that this branch works

Re: [Maria-developers] MariaDB multi-source replication testing at Booking.com

2015-06-29 Thread Lixun Peng
Hi Karoly, Can you share a 'pstack' result of Multi-Source target when OS/waits is high? And how about your options on my.cnf? In my mind, Multi-Source replication will not effect InnoDB. But if Source_1 and Source_2 will operating the same table, maybe cause some conflict on slave, then slave