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 connections from each client, sysbench shows latency of .3 msec (for both sides)
If I run with 13k from one client and 1k from the other, latency comes to .6 msec (for both sides)
I get that we are load balancing with 7k so latency improves but any ideas which part of MySQL server I should profile to see which area is messing it up with 13k+1k connection split- could it be poll() call? Or some other kernel area?
Thanks in advance for my pointers... Martin
PS: I hear that the same thing when run on kernel 2.6.32 doesn't show this bad latency witj 13+1 split...yet to be confirmed though
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Feb 05
Learner Study Re: Latency question - #of connections
Feb 05, 2015; 14:49
Learner Study
Re: Latency question - #of connections
Feb 06
Stewart Smith Re: Latency question - #of connections
Feb 06, 2015; 09:22
Stewart Smith
Re: Latency question - #of connections
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!