Re: [Maria-developers] parallel replication performance

2014-03-26 Thread Axel Schwenke
Hi Kristian, Kristian Nielsen wrote: > >> The poor performance of MySQL with 1 database is expected. However MySQL is >> much better with 32 databases. Even better than MariaDB :( > > Ok, so I looked closer at the numbers (of which there were quite a few, thanks > for doing this work :-). I have

Re: [Maria-developers] parallel replication performance

2014-03-26 Thread Kristian Nielsen
Axel Schwenke writes: > The poor performance of MySQL with 1 database is expected. However MySQL is > much better with 32 databases. Even better than MariaDB :( Ok, so I looked closer at the numbers (of which there were quite a few, thanks for doing this work :-). I have some idea of what could

Re: [Maria-developers] parallel replication performance

2014-03-25 Thread Axel Schwenke
Kristian Nielsen wrote: > A couple of things that can be adjusted are --slave-domain-parallel-threads > and --slave-parallel-max-queued. But I wouldn't expect them to have much > effect on a sysbench load. If you want, you could try increase > --slave-parallel-max-queued and set --slave-domain-par

Re: [Maria-developers] parallel replication performance

2014-03-25 Thread Kristian Nielsen
Axel Schwenke writes: >> In this test, are you sure that you are running MariaDB in GTID mode? >> >> CHANGE MASTER TO master_use_gtid=slave_pos > > Yes. This is how the shell code looks: > > mysql -S ${SLAVE_SOCKET} -u root -e "SET GLOBAL gtid_slave_pos=''" > mysql -S ${SLAVE_SOCKET} -u root

Re: [Maria-developers] parallel replication performance

2014-03-25 Thread Kristian Nielsen
Axel Schwenke writes: > The poor performance of MySQL with 1 database is expected. However MySQL is > much better with 32 databases. Even better than MariaDB :( I haven't had time to go through all the numbers and details yet, but just a quick check: In this test, are you sure that you are runn

Re: [Maria-developers] parallel replication performance

2014-03-25 Thread Axel Schwenke
Hi Kristian, Am 25.03.2014 15:55, schrieb Kristian Nielsen: > Axel Schwenke writes: > >> The poor performance of MySQL with 1 database is expected. However MySQL is >> much better with 32 databases. Even better than MariaDB :( > > I haven't had time to go through all the numbers and details yet