On Mon, Dec 8, 2014 at 3:02 PM, Wagner Bianchi <wagnerbianch...@gmail.com> wrote: > Hello Chris, > > Can pls you share the below command output... > > SHOW STATUS LIKE 'Threads%'; > SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet;
mysql> SHOW STATUS LIKE 'Threads%'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | Threads_cached | 422 | | Threads_connected | 92 | | Threads_created | 514 | | Threads_running | 1 | +-------------------+-------+ 4 rows in set (0.43 sec) mysql> SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet; +---------------------+---------------------+----------------------+ | @@thread_cache_size | @@net_buffer_length | @@max_allowed_packet | +---------------------+---------------------+----------------------+ | 1024 | 16384 | 16777216 | +---------------------+---------------------+----------------------+ 1 row in set (0.00 sec) mysql> The server is very not busy at all right now however. The issues seems to start happening once we've reach the 250 to 300 concurrent connection mark. I'm tempted to just through another 64GB of memory to the box and up the max connections, but 1st price of course would be to identify and resolve the problem, rather than just throwing hardware at the problem :-) > What about the limits.conf config on operating system level? They have been dealt with. mySQL has 4096 file descriptors available. Through all of this, not one single error is logged to the errorlog either. limits.conf: mysql soft nofile 4096 mysql hard nofile 4096 I'm personally actually leading more towards that this is a OS issue rather than a mysql issue, but I have no idea to where to even start looking to debug this :-( -- Chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
