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

2009-10-24 Thread MARK CALLAGHAN
On Sat, Oct 24, 2009 at 5:30 AM, Michael Widenius wrote: > > Hi! > >> "MARK" == MARK CALLAGHAN writes: > > > > MARK> 703     1425    2593    4379    4176    4110    maria.nostat > MARK> 684     1281    2439    4064    3896    3882    maria.stat > > MARK> oltp-ro run again for maria.nostat >

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

2009-10-24 Thread Michael Widenius
Hi! > "MARK" == MARK CALLAGHAN writes: MARK> 703     1425    2593    4379    4176    4110    maria.nostat MARK> 684     1281    2439    4064    3896    3882    maria.stat MARK> oltp-ro run again for maria.nostat MARK> 761 12782593440642074164 mari

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

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

2009-10-20 Thread MARK CALLAGHAN
On Tue, Oct 20, 2009 at 1:05 AM, Michael Widenius wrote: > > Hi! > >> "MARK" == MARK CALLAGHAN writes: > > MARK> On Mon, Oct 19, 2009 at 5:52 AM, Sergei Golubchik > wrote: >>> Hi, Monty! >>> >>> On Oct 19, Michael Widenius wrote: I just finished applying / modifying / rewriting th

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

2009-10-20 Thread Michael Widenius
Hi! > "MARK" == MARK CALLAGHAN writes: MARK> On Mon, Oct 19, 2009 at 5:52 AM, Sergei Golubchik wrote: >> Hi, Monty! >> >> 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.

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

2009-10-19 Thread Sergei Golubchik
Hi, MARK! On Oct 19, MARK CALLAGHAN wrote: > On Mon, Oct 19, 2009 at 5:52 AM, Sergei Golubchik wrote: > > 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. > > > > I wonder if any

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

2009-10-19 Thread MARK CALLAGHAN
Pardon my manual cut & paste, gmail didn't format the reply cleanly: >>> >From Monty I just finished applying / modifying / rewriting the userstats patch to MariaDB 5.2 and will commit this in a moment. As far as I know, the patch was originally made by Mark and his team, then addopted by Percona

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

2009-10-19 Thread MARK CALLAGHAN
On Mon, Oct 19, 2009 at 5:52 AM, Sergei Golubchik wrote: > Hi, Monty! > > 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. > > I wonder if anybody cares to monitor mutex usage in MySQL.

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

2009-10-19 Thread Sergei Golubchik
Hi, Monty! 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. I wonder if anybody cares to monitor mutex usage in MySQL. This patch adds few new global mutexes that are locked at least on