title: 2gb table with 10 million rows, late pagination select is slow
body: <p>I have table in MySQL with 10 million rows with 2 GB data 
  selecting IN LIFO format  data is slow  </p>
  
  <p><strong>Table engine</strong> is = <code>InnoDB</code></p>
  
  <p>table has one <strong>primary key</strong> and one <strong>unique key</strong></p>
  
  <pre><code>SELECT * FROM link LIMIT 999999 , 50;
  </code></pre>
  
  <p>how I improve the performance of the table. ?</p>
  
  <p><strong>table structure</strong> </p>
  
  <pre><code>id  int(11) NO  PRI NULL    auto_increment
  url varchar(255)    NO  UNI NULL    
  website varchar(100)    NO      NULL    
  state   varchar(10) NO      NULL    
  type    varchar(100)    NO      NULL    
  prio    varchar(100)    YES     NULL    
  change  varchar(100)    YES     NULL    
  last    varchar(100)    YES     NULL
  </code></pre>
  
  <p><strong>NOTE:</strong> 
  <code>SELECT * FROM link LIMIT 1 , 50;</code> is taking <code>.9ms</code> but current sql is taking <code>1000ms</code> its 1000 time taking more</p>