List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:May 16 2013 8:37am
Subject:Re: Innodb innodb_buffer_pool_size?
View as plain text  
Hi Rafal,

>I am trying to set the best value for innodb_buffer_pool_size. My system
has 6GB of ram.
>My question: how to tell if my innodb_buffer_pool_size is ok?

If this is a MySQL dedicated server,
In your case I would set it to 2GB-3GB.
You will have the whole data in RAM now and for some time.

>Does Buffer pool hit rate 1000 / 1000 mean that I can lower it?

No. It means it is doing fine. And if you don't need RAM for anything else
why lower it?

>Does Free buffers       0 mean that I should make it larger?

No. InnoDB will always try to allocate each block in the buffer pool.

>Eventually what else to check?

(a) mysql> SELECT engine,sum(data_length)/1024/1024 as
DATA_MB,sum(INDEX_LENGTH)/1024/1024 as INDEX_MB FROM
information_schema.tables GROUP BY engine;

To check the real size of the dataset.

(b) Note: mysql-server-5.0.58  you should upgrade to latest 5.0.96

Regards

Claudio

Thread
Innodb innodb_buffer_pool_size?Rafał Radecki16 May
  • Re: Innodb innodb_buffer_pool_size?Reindl Harald16 May
  • Re: Innodb innodb_buffer_pool_size?Claudio Nanni16 May
RE: Innodb innodb_buffer_pool_size?Vikas Shukla16 May
  • Re: Innodb innodb_buffer_pool_size?Reindl Harald16 May
    • RE: Innodb innodb_buffer_pool_size?Ilya Kazakevich16 May
      • Re: Innodb innodb_buffer_pool_size?Reindl Harald16 May
RE: Innodb innodb_buffer_pool_size?Vikas Shukla16 May