title: Most common and important SQL commands that solely apply to MyIsam storage engine?
body: <p>It has been recently come up into one of our discussions that moving an old legacy system using old MyISAM based MySQL deployment can't be easily replaced by an InnoDB based MySQL or MariaDB deployment. The reason that came up was that there were too many MyISAM only SQL commands all over the place. I haven't seen the code yet so I'm wondering what SQL commands where they referring to. </p>
  
  <p>I only know of SEVERAL like below which are associated with table locking. It will probably work with InnoDB still in theory, but more appropriate for MyISAM , <code>MERGE</code>, and <code>MEMORY</code> storage engines which support table locking.  </p>
  
  <pre><code>LOCK TABLES
  UNLOCK TABLES
  </code></pre>
  
  <p>If there are more, or point me to a collection of it. It will be highly appreciated.</p>
  
  <p><em>--edit--</em></p>
  
  <p>I'll put everything else I find below this line.</p>
  
  <pre><code>MATCH (http://dev.mysql.com/doc/refman/5.5/en//fulltext-search.html)
  </code></pre>