On 02/09/2010 6:05 p, Alexandre Vieira wrote:
> Hi Jangita,
> I'm 15779 innodb_buffer_pool_pages_free from a total of 22400. That's
> 246MB of 350MB free.
> | Innodb_buffer_pool_pages_data | 6020 |
> | Innodb_buffer_pool_pages_dirty | 1837 |
> | Innodb_buffer_pool_pages_flushed | 673837 |
> | Innodb_buffer_pool_pages_free | 15779 |
> | Innodb_buffer_pool_pages_latched | 0 |
> | Innodb_buffer_pool_pages_misc | 601 |
> | Innodb_buffer_pool_pages_total | 22400 |
> | Innodb_buffer_pool_read_ahead_rnd | 1 |
> | Innodb_buffer_pool_read_ahead_seq | 0 |
> | Innodb_buffer_pool_read_requests | 48471963 |
> | Innodb_buffer_pool_reads | 3497 |
> | Innodb_buffer_pool_wait_free | 0 |
> | Innodb_buffer_pool_write_requests | 21700478 |
> Why would I need to increase?
I'm guessing (just a guess) that you have alot free buffer_pool_size
because mysql doesn't use it because it cannot fit information into it
at one go so doesn't use it at all? Try and up it; if it doesn't work
you could always set it back.
Jangita | +256 76 91 8383 | Y! & MSN: jangita@stripped
Skype: jangita | GTalk: jangita.nyagudi@stripped