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?
Thanks
BR
AJ
On Thu, Sep 2, 2010 at 4:47 PM, Jangita <jangita@stripped> wrote:
> On 02/09/2010 4:46 p, Alexandre Vieira wrote:
>
>> John, Johnny,
>>
>> Thanks for the prompt answer.
>>
>> ...
>
> We also run some other applications in the server, but nothing that
>> consumes
>> all the CPU/Memory. The machine has almost 1GB of free memory and 50% of
>> idle CPU time at any time.
>>
>> TIA
>>
>> BR
>> Alex
>>
>
> Increase innodb_buffer_pool_size say to 1GB?
> --
> Jangita | +256 76 91 8383 | Y! & MSN: jangita@stripped
> Skype: jangita | GTalk: jangita.nyagudi@stripped
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
--
Alexandre Vieira - nullpt@stripped
