Very good share Reindl.
--
*Wagner Bianchi, MySQL Database Specialist*
Mobile: +55.31.8654.9510
E-mail: m...@wagnerbianchi.com
Twitter: @wagnerbianchijr
2014-12-08 12:05 GMT-02:00 Reindl Harald :
>
> Am 08.12.2014 um 14:56 schrieb Chris Knipe:
>
>> They have been dealt with. mySQL has 4096
Chris, thanks for you prompt reply. Try to raise up some configuration
regarding /etc/security/limits.conf
mysql soft nofile 10240
mysql hard nofile 40960
mysql soft nproc 10240
mysql hard nproc 40960
root soft nofile 10240
root hard nofile 40960
root soft nproc 10240
root hard nproc 40960
[root@
Am 08.12.2014 um 14:56 schrieb Chris Knipe:
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
that won't work well depending on the numbe
On Mon, Dec 8, 2014 at 3:02 PM, Wagner Bianchi
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%';
+---+---+
| Vari
Am 08.12.2014 um 14:04 schrieb Wagner Bianchi:
In some past experiences, firewall can add a small overhead in connection
establishment. If you're using iptables, you can try disable it for a second,
test the connection establishment to check if the overhead is being added by
the firewall and
In some past experiences, firewall can add a small overhead in connection
establishment. If you're using iptables, you can try disable it for a second,
test the connection establishment to check if the overhead is being added by
the firewall and enable that afterwards.
Let us know how's it goin
Hello Chris,
Can pls you share the below command output...
> SHOW STATUS LIKE 'Threads%';
> SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet;
What about the limits.conf config on operating system level?
-- WB, MySQL Oracle ACE
> Em 07/12/2014, às 20:03, "Chris Knipe" escr
FYI - just an example...
mysql> SELECT VERSION();
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:203720459
Current database: NNTP
+-+
| VERSION() |
+-+
| 5.5.38-0ubunt
