← Back to team overview

maria-discuss team mailing list archive

Re: Doubts about Thread Pool

 

Hi Roberto,

I do believe the idea of the thread pool was to get rid of the one
thread/connection paradigm, so all connections will be served by
potentially all threads.

Michael


On 16 September 2013 02:03, Roberto Spadim <roberto@xxxxxxxxxxxxx> wrote:

> Hi guys, I'm testing threadpool on windows with mariadb 10.0.4
>
> I'm running server with this command line:
> C:\Program Files\mariadb-10.0.4-win32\bin>mysqld --datadir=..\data\
> --log_error=..\log --port=3306 --thread_pool_max_threads=3
>
> Now I'm connected  with 10 clients:
> 2 rootlocalhost:41859 mysqlSleep 5 0.000 3root localhost:41860 Sleep18
> 0.0004 rootlocalhost:41861 Sleep 13 0.000 5root localhost:41862 Sleep11
> 0.0006 rootlocalhost:41867 Sleep 17 0.000 7root localhost:41955 Sleep9
> 0.0008 rootlocalhost:41966 Sleep 4 0.000 9root localhost:41969 Query0 initshow
> processlist 0.00010 rootlocalhost:42029 Sleep 9 0.000 11rootlocalhost:42032Sleep
> 4 0.000
>
> *generated 2013-09-15 22:02:41 by HeidiSQL 8.0.0.4464<http://www.heidisql.com/>
> *
>
> My question is... how i know what thread pool is running each connection?
>
> --
> Roberto Spadim
> SPAEmpresarial
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References