title: How long does it take to create an index in mysql?
body: <p>I recently got the advice to create some indexes, here is my sql code</p>
  
  <pre><code>CREATE INDEX my_idx1 ON identdb (name,long1,lat1,date,count);
  CREATE INDEX my_idx2 ON identdb (name,long1,lat1,date);
  CREATE INDEX my_idx3 ON identdb (long1,lat1,date);
  CREATE INDEX my_idx4 ON identdb (long1,lat1);
  </code></pre>
  
  <p>There are 7 million rows, 7 columns, and I am doing this on a local Database.</p>
  
  <p>It has been running for about 16 hours. Did I do something wrong?</p>