← Back to team overview

maria-discuss team mailing list archive

Re: Threadpool benchmarks / feature note


sorry :) thanks sergei

2014-01-30 Sergei Petrunia <psergey@xxxxxxxxxxxx>:
> On Thu, Jan 30, 2014 at 05:00:36AM -0200, Roberto Spadim wrote:
>> hum... an idiot question, i didn't think it about before asking...
>> why not allow one server running two tcp ports, or unix socket or
>> pipes or any other listening method? each one using a scheduler style,
>> TP (thread pool) or OTPC (one thread per client)?
> I thought this was supported:
> mysqld --help --verbose prints:
>   --extra-max-connections=#
>                       The number of connections on extra-port
>   --extra-port=#      Extra port number to use for tcp connections in a
>                       one-thread-per-connection manner. 0 means don't use
>                       another port
>> for example... i have some queries that execute nice with OTPC (and
>> it's easy to change program to only use a tcp port in this case), but
>> they could lock many queries if execute with TP (again it's easy to
>> tell what scheduler is better and select the right tcp port), and some
>> queries runs nice with any one
>> in this case, why not allow a tcp port for TP, and one tcp port for
>> OTPC? ok many lock problems?
>> maybe allow a new option at client connect function (like compress
>> option) that allow select of what kind of schedule should be used at
>> server side? TP or OTPC or maybe another one...
> BR
>  Sergei
> --
> Sergei Petrunia, Software Developer
> MariaDB | Skype: sergefp | Blog: http://s.petrunia.net/blog

Roberto Spadim
Eng. Automação e Controle