Hi.
We have a MySQL database as backend on our 15.000 user mailserver.
This MySQL instance receives a large amount of connections, each
performing just a small amount of processing (a few SELECT:s) before
disconnecting.
Our mysql.err log is filling up with lines like the below:
051020 10:50:29 Aborted connection 1023489 to db: 'XXX' user: 'YYY'
host: `ZZZ' (Got an error reading communication packets)
On an typical day, there are some 600.000 connects to the database,
and about 5.000 of those connection attempts lead to a connect error
(that's almost 1%). If it is the mysql client connecting in these
cases, the error code returned is 2002, but most connects come from
other programs using libmysql.
Can someone give us a hint what might be lacking in our setup to
cause this behaviour? What can we alter to make this stop happening?
Regards,
/Viktor...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]