title: MySQL - How to diagnose cause of warning "Aborted connection - (Got timeout reading communication packets)"
body: <p>I'm having some problems on our fairly busy Windows 2008 R2 web server, running MySQL.</p>
  
  <p>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.</p>
  
  <p>Having turned on warning logging in MySQL, I am seeing repeated logs of the following warning:</p>
  
  <pre><code>[Warning] Aborted connection 7153 to db user: 'XXXX' host: 'XXXXXX' (Got timeout reading communication packets)
  </code></pre>
  
  <p>The docs here <a href="http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html">http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html</a> suggest a range of potential network related causes. </p>
  
  <p>Some of the configuation under "Advanced Networking":</p>
  
  <p>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</p>
  
  <p>My question is, how can I better diagnose what is causing this issue, rather than just playing with settings and waiting?</p>
  
  <p>Thanks in advance</p>