List:General Discussion« Previous MessageNext Message »
From:Vikas Shukla Date:May 16 2013 9:01am
Subject:RE: Innodb innodb_buffer_pool_size?
View as plain text  
Hi claudio,

The best value for innodb buffer pool size is considered to be 60 to 70 percent of ram. 
So in your case, this must be around 4 gb.
That would work better.

Regards.

Vikas

-----Original Message-----
From: "Claudio Nanni" <claudio.nanni@stripped>
Sent: ‎16-‎05-‎2013 14:12
To: "Rafał Radecki" <radecki.rafal@stripped>
Cc: "mysql@stripped" <mysql@stripped>
Subject: Re: Innodb innodb_buffer_pool_size?

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