title: Howto warm up a mysql database
body: <p>I would like to know howto warm up a mysql database.</p>
  
  <p>I have read you have to size your innodb_buffer_pool_size with following query:</p>
  
  <pre><code>SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM 
  (SELECT SUM(data_length+index_length) Total_InnoDB_Bytes
  FROM information_schema.tables WHERE engine='InnoDB') A;`
  </code></pre>
  
  <p>Because my database is rather small, i use it without <code>ceiling</code> and i get sometime like 0,200.
  So i altered my innodb_buffer_pool_size to 256MB. (I only have 1 GB ram).</p>
  
  <p>I've read somewhere you can use following query <code>SELECT COUNT(*) FROM Fiets FORCE INDEX (PRIMARY);</code></p>
  
  <p>But my <code>SHOW GLOBAL STATUS LIKE 'innodb_buffer_pool_pages_%';</code> shows that only 4391 of 16383 are filled.</p>
  
  <p>How do i warm my database at start up? Can someone give me a sql query?</p>
  
  <p>@Juhana. I know my database is small, but i would like to get the best performance. (school project)</p>