title: Will a MySQL SELECT statement interrupt INSERT statement?
body: <p>I have a mysql table that keep gaining new records every 5 seconds.</p>
  
  <p>The questions are</p>
  
  <ol>
  <li><p>can I run query on this set of data that may takes more than 5 seconds?</p></li>
  <li><p>if <strong>SELECT</strong> statement takes more than 5s, will it affect the scheduled <strong>INSERT</strong> statement?</p></li>
  <li><p>what happen when <strong>INSERT</strong> statement invoked while <strong>SELECT</strong> is still running, will <strong>SELECT</strong> get the newly inserted records?</p></li>
  </ol>