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 _______________________________________________ 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