List:General Discussion« Previous MessageNext Message »
From:Alexandre Vieira Date:September 2 2010 4:05pm
Subject:Re: Performance problems on MySQL
View as plain text  
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

Thread
Performance problems on MySQLAlexandre Vieira2 Sep
  • Re: Performance problems on MySQLJangita2 Sep
    • Re: Performance problems on MySQLAlexandre Vieira2 Sep
      • Re: Performance problems on MySQLJangita3 Sep
  • RE: Performance problems on MySQLTravis Ard2 Sep
    • Re: Performance problems on MySQLAlexandre Vieira2 Sep
Re: Performance problems on MySQLAlexandre Vieira3 Sep
  • Re: Performance problems on MySQLJohnny Withers3 Sep
    • Re: Performance problems on MySQLAlexandre Vieira3 Sep
      • Re: Performance problems on MySQLJohnny Withers3 Sep
        • Re: Performance problems on MySQLAlexandre Vieira3 Sep
          • Re: Performance problems on MySQLJohnny Withers3 Sep
            • Re: Performance problems on MySQLAlexandre Vieira3 Sep
              • Re: Performance problems on MySQLJohnny Withers3 Sep
                • Re: Performance problems on MySQLAlexandre Vieira3 Sep
                  • Re: Performance problems on MySQLJohnny Withers3 Sep
                    • Re: Performance problems on MySQLMySQL)5 Sep
  • Re: Performance problems on MySQLmos6 Sep
    • Re: Performance problems on MySQLAlexandre Vieira6 Sep
      • Re: Performance problems on MySQLAlexandre Vieira6 Sep