title: Stopping table locks for MYISAM tables
body: <p>I have a MYISAM table on which long-running SELECT statements are conducted. Do these statements cause locks on the tables that are being read? If so, how do you stop the locks from occurring?</p>
  
  <p>According to <a href="https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html</a>:</p>
  
  <blockquote>
    <p>MySQL uses table-level locking for MyISAM, MEMORY, and MERGE tables,
    permitting only one session to update those tables at a time. This
    locking level makes these storage engines more suitable for read-only,
    read-mostly, or single-user applications.</p>
  </blockquote>
  
  <p>Does this also mean that <code>SELECT</code> statements create locks? </p>