Something like this? Using <code>SHOW VARIABLES</code> and <code>SHOW GLOBAL STATUS</code>: <i>Expression:</i> <code>innodb_buffer_pool_size / _ram</code><br> <i>Meaning:</i> % of RAM used for InnoDB buffer_pool<br> <i>Recommended range:</i> 60~80%<br> <br> <i>Expression:</i> <code>Innodb_buffer_pool_reads / Innodb_buffer_pool_read_requests</code><br> <i>Meaning:</i> Read requests that had to hit disk<br> <i>Recommended range:</i> 0-2%<br> <i>What to do if out of range:</i> Increase innodb_buffer_pool_size if you have enough RAM.<br> <br> <i>Expression:</i> <code>Innodb_pages_read / Innodb_buffer_pool_read_requests</code><br> <i>Meaning:</i> Read requests that had to hit disk<br> <i>Recommended range:</i> 0-2%<br> <i>What to do if out of range:</i> Increase innodb_buffer_pool_size if you have enough RAM.<br> <br> <i>Expression:</i> <code>Innodb_pages_written / Innodb_buffer_pool_write_requests</code><br> <i>Meaning:</i> Write requests that had to hit disk <br> <i>Recommended range:</i> 0-15%<br> <i>What to do if out of range:</i> Check innodb_buffer_pool_size<br> <br> <i>Expression:</i> <code>Innodb_buffer_pool_reads / Uptime</code><br> <i>Meaning:</i> Reads<br> <i>Recommended range:</i> 0-100/sec.<br> <i>What to do if out of range:</i> Increase innodb_buffer_pool_size?<br> <br> <i>Expression:</i> <code>(Innodb_buffer_pool_reads + Innodb_buffer_pool_pages_flushed) / Uptime</code><br> <i>Meaning:</i> InnoDB I/O<br> <i>Recommended range:</i> 0-100/sec.<br> <i>What to do if out of range:</i> Increase innodb_buffer_pool_size?<br> <br> <i>Expression:</i> <code>Innodb_buffer_pool_pages_flushed / Uptime</code><br> <i>Meaning:</i> Writes (flushes)<br> <i>Recommended range:</i> 0-100/sec.<br> <i>What to do if out of range:</i> Increase innodb_buffer_pool_size?<br> <br> <i>Expression:</i> <code>Innodb_buffer_pool_wait_free / Uptime</code><br> <i>Meaning:</i> Counter for when there are no free pages in buffer_pool. That is, all pages are dirty.<br> <i>Recommended range:</i> 0-1/sec.<br> <i>What to do if out of range:</i> First be sure innodb_buffer_pool_size is set reasonably; if still trouble, decrease innodb_max_dirty_pages_pct<br> <br>