title: MySQL memory requirement
body: <p>I have scenarios like below:</p>
  
  <ol>
  <li>Database with single table (innodb storage engine)</li>
  <li>This table is ~350GB including table &amp; index.</li>
  <li>Table size ~250GB</li>
  <li>Index Size ~110GB</li>
  <li>Table is partitioned and size of partition ranges from 1G to 10G</li>
  <li>Table contains 3 indexes.  </li>
  <li>One is primary (with non-auto increment column ). </li>
  <li>Rest two index is non-unique</li>
  <li>No other application is running on this server.</li>
  <li>Server is having 128 GB of RAM</li>
  <li>Our Query is hitting one partition at one point.</li>
  <li>Multiple such queries can hit for different partitions.</li>
  </ol>
  
  <p>I just learned that I would need 1.15 times innodb buffer.  I am running "<strong>mysqltuner.pl</strong>" and it is recommending me for ~417GB of innodb buffer size.  I don't know why it is recommending so much of memory for DB.</p>
  
  <p>Would anybody come up with suggestion on the size of INNODB_BUFFER_POOL_SIZE. </p>
  
  <p>Regards,
  Sanjeeva </p>