title: Perfectly good queries on my sql taking more than 5 seconds
body: <p>Lately we are seeing some queries in mysql(master) logs but no idea why they are shown there:
  Queries are <code>select/update table where id = &lt;some integer&gt;</code>.</p>
  
  <hr>
  
  <ol>
  <li>There is index on id</li>
  <li>table size is below 100 000</li>
  <li>Rows scanned are in hundreds (sometimes &lt; 100)</li>
  <li>Server is running on extremely good hardware</li>
  <li>there are no joins involved</li>
  <li>We do not see any heavy activity running on database at that time</li>
  <li>tables are innodb</li>
  <li>the same queries generally don’t even take 50ms, but sometimes all the execution of these queries take about 4-8 seconds</li>
  </ol>
  
  <p>One observation was all the similar "non-slow-but-weirdly-taking-high-time" queries take almost the same amount of time for some duration . I.e. queries like stated in the top will all take about 4.35 seconds with variation of 0.05 seconds.</p>
  
  <p>Does the network latency/packets-drop affect mysql query timing?</p>