Web lists-archives.com

Re: mysql strangeness...




On Mon, Dec 8, 2014 at 3:02 PM, Wagner Bianchi
<wagnerbianchijr@xxxxxxxxx> 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