I'm having some problems on our fairly busy Windows 2008 R2 web server, running MySQL.
Applications are intermittently crashing, and logs are commonly pointing to MySQL as a route cause, in that the applications cannot connect to MySQL. This is not affecting all users, just a few unlucky ones.
Having turned on warning logging in MySQL, I am seeing repeated logs of the following warning:
[Warning] Aborted connection 7153 to db user: 'XXXX' host: 'XXXXXX' (Got timeout reading communication packets)
The docs here http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html suggest a range of potential network related causes.
Some of the configuation under "Advanced Networking":
Max Packet Size: 128 M (We increased this from 64 M yesterday) Wait timeout: 20 Max Connections: 1000 Max Conn per: 1000 Retry count: 5
My question is, how can I better diagnose what is causing this issue, rather than just playing with settings and waiting?
Thanks in advance