title: how to improve select performance in mysql?
body: <p>I have 1034961 rows data from database(mysql) table. </p>
  
  <p>structure.. </p>
  
  <p>table : tb_blog_image</p>
  
  <pre><code>    |   id(pk)   |   link(TEXT)   |   img_link(TEXT)   |
      |     1      |blogpost.com/aaa|http://sky.png      |
      |     2      |blogpost.com/aaa|http://girl.png     |
      |     3      |blogpost.com/aaa|http://cad.png      |
  </code></pre>
  
  <p>now, I want to select specific img_link list from tb_blog_images. </p>
  
  <p>sql..</p>
  
  <pre><code>    select link, img_link
      from tb_blog_image
      where link = 'blogpost.com/aaa';
  </code></pre>
  
  <p>result 38rows 6.37sec</p>
  
  <p>how to improve select performance?
  make link column to index?
  table normalization?</p>
  
  <p>I want to run within 1sec. </p>
  
  <p>I want to listen various tips. </p>