Re: Latency question - #of connections

2015-02-05 Thread Stewart Smith
Learner Study writes: > 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 late

Re: Latency question - #of connections

2015-02-05 Thread Learner Study
I'd be doing it and would provide update. BTW, since the query/sec rate is too low, I doubt if it would show anything. but would try and update. Both clients aggregate at a switch and come into my server as a single 10G. So it shouldn't matter from poll() system call perspective. I'm also thinkin

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 connection

ANN: Database Designer for MySQL 2.1.4 is out!

2015-02-05 Thread Aleksander Andreev
This release provide support for latest character sets and collations, support for fractional seconds in temporal data types, ON UPDATE clause for DATETIME data type. Full change log: [!] Support for Fractional Seconds in temporal data types added [+] ON UPDATE clause support added for DATETIME f