Thanks! 
I did a few checks:

There is only one single instance of mysql running on the machine (running 
Ubuntu Netbook Ed.). 

> - aborted_clients and aborted_connections in the mysql 'show status' output
+-----------------------------------+-----------+
| Variable_name                     | Value     |
+-----------------------------------+-----------+
| Aborted_clients                   | 0         |
| Aborted_connects               | 0         |


> - anything in the mysql error log about 'too many clients'?
No, the error log is empty and syslog doesn't hold any indication of mysql 
failing either.

> - default connect_timeout is 10, so you could try bumping that up if
> it seems like the client is timing out trying to get a connection


This is a good point. I tweaked the following settings and hope that it will 
change the behaviour:

wait_timeout=60 #don't wanna wait 8h for mysql to forget about a connection
connect_timeout=20 #increased from 10
interactive_timeout=120 #decreased from 8h

I'll report back when it failed or finished...

Thanks,
 Henning
--
Henning Weiler
CERN - Open Access Section
Postbox C24300

Tel: +41-22-767-7835
eMail: [email protected]


Reply via email to