Re: Merging multiple SQL requests

entify the root-cause... Thanks! On Sat, Feb 21, 2015 at 5:33 PM, Jay Ess 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

Re: Merging multiple SQL requests

ernel 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 wrote: > Learner Study writes: >> Is it possible for MySQL server to automatically merge responses for >> different queries into a single

Merging multiple SQL requests

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:http://li

relation between innodb_thread_concurrency and MySQL threads

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

Re: Latency question - #of connections

. I'm also thinking of using ftrace to debug it...any other ideas? Thanks a lot! On Thu, Feb 5, 2015 at 2:22 PM, Stewart Smith wrote: > Learner Study writes: >> Setup: >> MySQL 5.6.16 + thread pool extensions running on 3.18 kernel >> >> Two sysbench clients ru

Latency question - #of connections

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 connection