title: Very big data in mysql table. Even select statements take much time
body: <p>I am working on a database and its a pretty big one with 1.3 billion rows and around 35 columns. Here is what i get after checking the status of the table:</p>
  
  <pre><code>Name:Table Name
  Engine:InnoDB
  Version:10
  Row_format:Compact
  Rows:12853961
  Avg_row_length:572
  Data_length:7353663488
  Max_data_length:0
  Index_length:5877268480
  Data_free:0
  Auto_increment:12933138
  Create_time:41271.0312615741
  Update_time:NULL
  Check_time:NULL
  Collation:utf8_general_ci
  Checksum:NULL
  Create_options:
  Comment:InnoDB free: 11489280 kB
  </code></pre>
  
  <p>The Problem I am facing that even a single select query takes too much time to process for example a query  <code>Select * from Table_Name limit 0,50000</code> takes around 2.48 minutes
  Is that expected?</p>
  
  <p>I have to make a report in which I have to use the whole historical data, that is whole 1.3 bil rows. I could do this batch by batch but then I would have to run queries which are  taking too much time many times again and again.  </p>
  
  <p>When the simple query is taking so much time I am not able to do any other complex query which needs joins and case statements.</p>