maria-discuss team mailing list archive
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:
> 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...
> Sergei Petrunia, Software Developer
> MariaDB | Skype: sergefp | Blog: http://s.petrunia.net/blog
Eng. Automação e Controle