]
Sent: Sunday, December 07, 2014 11:34 PM
To: 'mysql@lists.mysql.com'
Subject: mysql strangeness...
Hi,
I have a not so busy MySQL server (+- 150 Selects/sec, 180 Deletes/Sec,
320 Updates/Sec, 90 Inserts/Sec and 200 Replace/Sec), max 512 concurrent
connections.
The server is running
.
-Original Message-
From: Chris Knipe [mailto:sav...@savage.za.org]
Sent: Sunday, December 07, 2014 11:34 PM
To: 'mysql@lists.mysql.com'
Subject: mysql strangeness...
Hi,
I have a not so busy MySQL server (+- 150 Selects/sec, 180 Deletes/Sec,
320 Updates/Sec, 90 Inserts/Sec
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
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%';
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
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
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 h.rei...@thelounge.net:
Am 08.12.2014 um 14:56 schrieb Chris Knipe:
They have been dealt
@lists.mysql.com'
Subject: mysql strangeness...
Hi,
I have a not so busy MySQL server (+- 150 Selects/sec, 180 Deletes/Sec,
320 Updates/Sec, 90 Inserts/Sec and 200 Replace/Sec), max 512 concurrent
connections.
The server is running on a Dell R720 with 64GB Ram, Xeon E5-2620. Data is
on a 4 x 3TB