Radecki radecki.ra...@gmail.com
Cc: mysql@lists.mysql.com 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
? the best value is as large as the
expected dataset, more is wasting system ressources
-Original Message-
From: Claudio Nanni claudio.na...@gmail.com
Sent: 16-05-2013 14:12
To: Rafał Radecki radecki.ra...@gmail.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Subject: Re: Innodb
Hi All.
I am trying to set the best value for innodb_buffer_pool_size. My system
has 6GB of ram.
My system is:
2.6.32-279.19.1.el6.centos.plus.x86_64
CentOS release 6.3 (Final)
mysql-server-5.0.58
My current setting:
innodb_buffer_pool_size = 1024M
(my.cnf attached)
From show innodb
Sorry I failed to specify ghatna is only applicable when the database is quiet
large.
Vikas
-Original Message-
From: Reindl Harald h.rei...@thelounge.net
Sent: 16-05-2013 14:43
To: mysql@lists.mysql.com mysql@lists.mysql.com
Subject: Re: Innodb innodb_buffer_pool_size?
Am
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 big as
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
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.
Hi Dan,
You never really say what your memory problems are. Is MySQL crashing
because you're trying to use too much memory?
more comments inline
On 5/11/06, Dan Trainor [EMAIL PROTECTED] wrote:
What I'm dealing with here is memory problems using MySQL 5.0.19 under
FreeBSD. Although
Hello, all -
It's been a while since I've posted here, but I read the list daily.
Thanks for all the help.
What I'm dealing with here is memory problems using MySQL 5.0.19 under
FreeBSD. Although I've enabled allocation of more memory per-process,
as described by the FreeBSD notes for