List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:December 18 2009 8:05am
Subject:Re: RE: Innodb buffer pool size filling up
View as plain text  
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.richards@stripped> 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:
jschwartz@stripped] Sent: 01 Dece...
--

MySQL General Mailing List For list archives:
http://lists.mysql.com/mysqlTo unsubscribe: http:/...

Thread
Innodb buffer pool size filling upmachiel.richards1 Dec
  • RE: Innodb buffer pool size filling upNeil Aggarwal1 Dec
    • RE: Innodb buffer pool size filling upmachiel.richards1 Dec
      • Re: Innodb buffer pool size filling upClaudio Nanni1 Dec
        • RE: Innodb buffer pool size filling upmachiel.richards1 Dec
          • Re: Innodb buffer pool size filling upClaudio Nanni1 Dec
          • RE: Innodb buffer pool size filling upJerry Schwartz1 Dec
            • RE: Innodb buffer pool size filling upmachiel.richards18 Dec
              • Re: RE: Innodb buffer pool size filling upClaudio Nanni18 Dec
                • RE: RE: Innodb buffer pool size filling upmachiel.richards18 Dec
              • RE: Innodb buffer pool size filling upJerry Schwartz18 Dec