Re: [Maria-developers] Userstats patch applied to MariaDB 5.2

2009-10-21 Thread MARK CALLAGHAN
On Wed, Oct 21, 2009 at 3:04 PM, Michael Widenius wrote: > > Hi! > >> "MARK" == MARK CALLAGHAN writes: > > MARK> This includes results from sysbench for Maria 5.2 with/without > MARK> userstat enabled and for several other binaries. The results are > MARK> throughput (transactions per second)

Re: [Maria-developers] Userstats patch applied to MariaDB 5.2

2009-10-21 Thread Michael Widenius
Hi! > "MARK" == MARK CALLAGHAN writes: MARK> This includes results from sysbench for Maria 5.2 with/without MARK> userstat enabled and for several other binaries. The results are MARK> throughput (transactions per second) for 1, 2, 4, 8, 16, 32 concurrent MARK> sessions. MARK>

Re: [Maria-developers] Userstats patch applied to MariaDB 5.2

2009-10-21 Thread Michael Widenius
Hi! > "MARK" == MARK CALLAGHAN writes: MARK> Pardon my manual cut & paste, gmail didn't format the reply cleanly: No problems MARK> Thanks for cleaning this up. MARK> The original implementations of SHOW USER_STATS and SHOW TABLE_STATS MARK> had performance problems. SHOW TABLE_STATS w

Re: [Maria-developers] Userstats patch applied to MariaDB 5.2

2009-10-21 Thread MARK CALLAGHAN
This includes results from sysbench for Maria 5.2 with/without userstat enabled and for several other binaries. The results are throughput (transactions per second) for 1, 2, 4, 8, 16, 32 concurrent sessions. This tests many binaries including 5.0.37 with the v2 Google patch (aka 503

Re: [Maria-developers] Userstats patch applied to MariaDB 5.2

2009-10-21 Thread Michael Widenius
Hi! > "MARK" == MARK CALLAGHAN writes: MARK> I am willing to bet that Monty's patch makes sysbench readonly much MARK> slower with high concurrency on an 8-core server. But those problems MARK> have been fixed in recent versions of the patch. >> >> One should note that I changed the patc

Re: [Maria-developers] Userstats patch applied to MariaDB 5.2

2009-10-21 Thread Michael Widenius
Hi! > "Sergei" == Sergei Golubchik writes: Sergei> Hi, Monty! Sergei> On Oct 19, Michael Widenius wrote: >> >> I just finished applying / modifying / rewriting the userstats patch >> to MariaDB 5.2 and will commit this in a moment. Sergei> I wonder if anybody cares to monitor mutex usage