List:Maria Storage Engine« Previous MessageNext Message »
From:Vadim Tkachenko Date:March 13 2009 2:08pm
Subject:Re: [Maria-developers] Working on microsecond patches
View as plain text  
Michael,

Thread-pool should be used very carefully.

We tested it and InnoDB hangs in sysbench benchmarks when count of
client connection > size of thread-pool.

The problem is transaction state. Some connections may do internals
locks and after that could not enter to pool, because all slots are busy.

I expect you will have the same problem with Maria when it can fully
support transactions.


Michael Widenius wrote:
> Hi!
> 
> Just wanted to inform that I just pushed and extended pool-of-threads
> handling to the active MariaDB tree at launchpad.
> 
>
> http://askmonty.org/wiki/index.php/MariaDB_versus_MySQL#Pool_of_threads_.28limited_sets_of_threads_handling_all_queries.29
> 
> I plan to during the next few days also add the following patches to
> MariaDB:
> 
> http://www.percona.com/mysql/5.0.77-b13/patches/microslow_innodb.patch
> http://www.percona.com/mysql/5.0.77-b13/patches/microsec_process.patch
> 
> Regards,
> Monty
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to     : maria-developers@stripped
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
> 


-- 
Vadim Tkachenko, CTO
Percona Inc.
ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.percona.com/

  Attend the 2009 Percona Performance Conference
  April 22-23 - http://conferences.percona.com/
Thread
Working on microsecond patchesMichael Widenius13 Mar
  • Re: [Maria-developers] Working on microsecond patchesVadim Tkachenko13 Mar
    • Re: [Maria-developers] Working on microsecond patchesMichael Widenius18 Mar
      • Re: [Maria-developers] Working on microsecond patchesJeremiah Gowdy18 Mar
        • Re: [Maria-developers] Working on microsecond patchesMichael Widenius8 Apr
      • Re: [Maria-developers] Working on microsecond patchesMARK CALLAGHAN18 Mar
        • Re: [Maria-developers] Working on microsecond patchesMichael Widenius8 Apr
          • Re: [Maria-developers] Working on microsecond patchesMARK CALLAGHAN9 Apr