sorry :) thanks sergei 2014-01-30 Sergei Petrunia <psergey@askmonty.org>:
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 SPAEmpresarial Eng. Automação e Controle