[TurkeySub]

Originally Posted by snakes1100

To clarify your answer, if he was using to many connections, why is he not experiencing a error such as "max_connections" limit error, unfortanately, you can NOT use more connections that the server allows.

To try and help combat this issue, you should adjust the 1st of the two variables in my.cnf/my.ini & HUP sql.

wait_timeout = 120 (adjust this in multiples of 60 until the error stops.)
connect_timeout = 120

The above is NOT a fix, there are most likely issues with your coding/programs using & not closing connections or bad indexes or slow queries, these need to be looked at & corrected.

Good point and that brings me to another item. If the file you are trying to attach is larger than the max_packet_size in your my.cnf it will also fail to upload.

The easiest way may be to change your attachments to use the file system as opposed to the sql server, it would lead to a smaller sql DB and less work on the DB server.