title: How to disable index in innodb
body: <p>I'm trying to speed up bulk insert in an InnoDB table by temporary disabling   its indexes:</p>
  
  <pre><code>ALTER TABLE mytable DISABLE KEYS;
  </code></pre>
  
  <p>But it gives a <strong>warning</strong>:</p>
  
  <pre><code>+-------+------+-------------------------------------------------------------+
  | Level | Code | Message                                                     |
  +-------+------+-------------------------------------------------------------+
  | Note  | 1031 | Table storage engine for 'mytable' doesn't have this option |
  +-------+------+-------------------------------------------------------------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>How can we disable the indexes?</p>
  
  <p>What alternatives are there to avoid using the index when doing bulk inserts?</p>
  
  <p>How can we speed up the process?</p>