Thank you very much.
This now explains a lot.
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: 18 December 2009 10:05 AM
To: machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: RE: Innodb buffer pool size filling up
Machiel,
That is how it is supposed to work.
You assign a certain amount of memory(RAM) to it and the database engine
then manages it. It is highly desirable that this buffer is fully used, and
if the growing curve is slow it is because it is not undersized. If you
really need more ram for other uses in your system you can lower it a
little, but I think you are using this box only for MySQL and a 'good'
practice is to use 70/80% of system Ram ONLY for innodb buffer pool.
Cheers
Claudio
On 18 dec 2009 06:34, "machiel.richards" <machiel.richa...@gmail.com> wrote:
Good Morning all
QUOTE: "We have a MySQL database where the
INNODB_BUFFER_POOL_SIZE keeps on filling up"
I have monitored this issue for the last couple of weeks and even
though the buffer pool usage is increasing slowly, it is still heading to
become 100% full.
It used to vary in the past where it would increase and decrease
each day as required, however this does not seem to be happening anymore.
Does anybody know whether there is a process that is supposed to
manage this or otherwise clear this occasionally that might not be working?
We are getting quite a bit of issues with the client wanting to know
why this is happening, however thus far I haven't been able to find any
conclusive answers, not even through google.
Any assistance would be appreciated.
Thanking everyone in advance.
Regards
Machiel
-----Original Message----- From: Jerry Schwartz
[mailto:jschwa...@the-infoshop.com] Sent: 01 Dece...
--
MySQL General Mailing List For list archives: http://lists.mysql.com/mysql
To unsubscribe: http:/...
