title: MySQL Large Datasets
body: <p>I have large sets of data. Over 40GB that I loaded in MySQL table. I am trying to perform simple queries like <code>select * from tablename</code> but it takes gazillion minutes to run and eventually times out. If I set a limit, the execution is fairly fast ex: <code>select * from tablename limit 1000</code>.
  The table has over 200 million records.</p>
  
  <ul>
  <li>Tried creating indexes on some columns and that failed too after 3 hours of execution.</li>
  </ul>
  
  <p>Any tips on working with these types of datasets?</p>