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
Am 16.05.2013 13:31, schrieb Ilya Kazakevich:
>> hwo would a innodb_buffer_pool larger than the whole database make
>> anything better? the best value is as large as the expected dataset, more is
>> wasting system ressources
>
> You also may need space for adaptive indexes, locks etc so it is re
Am 16.05.2013 10:11, schrieb Rafał Radecki:
> I am trying to set the best value for innodb_buffer_pool_size. My system has
> 6GB of ram.
>
> innodb_buffer_pool_size = 1024M
>
> Size of innodb tables:
> du -h /mysql/ibdata1
> 1.8G/mysql/ibdata1
in the best case innodb_buffer_pool_size as b
Sorry I failed to specify ghatna is only applicable when the database is quiet
large.
Vikas
-Original Message-
From: "Reindl Harald"
Sent: 16-05-2013 14:43
To: "mysql@lists.mysql.com"
Subject: Re: Innodb innodb_buffer_pool_size?
Am 16.05.2013 11:01, schrieb
better? the best value is as large as the
expected dataset, more is wasting system ressources
> -Original Message-
> From: "Claudio Nanni"
> Sent: 16-05-2013 14:12
> To: "Rafał Radecki"
> Cc: "mysql@lists.mysql.com"
> Subject: Re: Inno
ki"
Cc: "mysql@lists.mysql.com"
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