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@spadim.com.br> 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.000
4 rootlocalhost:41861 Sleep 13 0.000
5root localhost:41862 Sleep11 0.000
6 rootlocalhost:41867 Sleep 17 0.000
7root localhost:41955 Sleep9 0.000
8 rootlocalhost:41966 Sleep 4 0.000
9root localhost:41969 Query0 initshow processlist 0.000
10 rootlocalhost:42029 Sleep 9 0.000
11root localhost:42032 Sleep4 0.000

generated 2013-09-15 22:02:41 by HeidiSQL 8.0.0.4464


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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp