Re: Merging multiple SQL requests

2015-02-22 Thread Learner Study
-cause... Thanks! On Sat, Feb 21, 2015 at 5:33 PM, Jay Ess li...@netrogenic.com wrote: On 2015-02-15 23:55, Learner Study wrote: Hello experts, Is it possible for MySQL server to automatically merge responses for different queries into a single response? Are there any kernel parameters

Re: Merging multiple SQL requests

2015-02-15 Thread Learner Study
timer ticks etc. Is there anything else to watch out for..pointers would be appreciated. Thanks On Sun, Feb 15, 2015 at 4:10 PM, Stewart Smith stew...@linux.vnet.ibm.com wrote: Learner Study learner.st...@gmail.com writes: Is it possible for MySQL server to automatically merge responses

Merging multiple SQL requests

2015-02-15 Thread Learner Study
Hello experts, Is it possible for MySQL server to automatically merge responses for different queries into a single response? Are there any kernel parameters that may dictate that? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

relation between innodb_thread_concurrency and MySQL threads

2015-02-07 Thread Learner Study
Hello, Could someone educate me on relation between innodb_thread_concurrency and number of MySQL threads running on the server with thread pool feature in Enterprise version of MySQL (based on release 5.6.16 (.4)?) If I set innodb_thread_concurrency=32, how many mysql threads are expected to be

Re: Latency question - #of connections

2015-02-05 Thread Learner Study
thinking of using ftrace to debug it...any other ideas? Thanks a lot! On Thu, Feb 5, 2015 at 2:22 PM, Stewart Smith stew...@linux.vnet.ibm.com wrote: Learner Study learner.st...@gmail.com writes: Setup: MySQL 5.6.16 + thread pool extensions running on 3.18 kernel Two sysbench clients running from

Latency question - #of connections

2015-02-05 Thread Learner Study
Hello MySQL experts, I am new to MySQL and am seeing following behavior Setup: MySQL 5.6.16 + thread pool extensions running on 3.18 kernel Two sysbench clients running from different PCs with total of 14k connections, each connection doing 2 select queries per sec. When I specify 7k