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 <jang...@jangita.com> 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: jang...@yahoo.com > Skype: jangita | GTalk: jangita.nyag...@gmail.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=nul...@gmail.com > > -- Alexandre Vieira - nul...@gmail.com