List:General Discussion« Previous MessageNext Message »
From:Jangita Date:September 3 2010 9:48am
Subject:Re: Performance problems on MySQL
View as plain text  
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?
>
> Thanks
>
> BR
> AJ
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
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