Web lists-archives.com

Re: mysql strangeness...





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 enable that afterwards.

for sure not, iptables handles thousands of new connections per second with no measureable overhead, especially on 127.0.0.1 which has typically a early ACCEPT rule

http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

Em 07/12/2014, às 20:03, "Chris Knipe" <savage@xxxxxxxxxxxxx> escreveu:

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-0ubuntu0.12.04.1-log |
+-----------------------------+
1 row in set (33.94 sec)


mysql> SELECT VERSION();
+-----------------------------+
| VERSION()                   |
+-----------------------------+
| 5.5.38-0ubuntu0.12.04.1-log |
+-----------------------------+
1 row in set (0.00 sec)


This is from the mysql client running on the same host as the mysql server,
connected to localhost via TCP.  Current connections to the DB was at about
200 out of 500

Attachment: signature.asc
Description: OpenPGP digital signature