List:General Discussion« Previous MessageNext Message »
From:machiel.richards Date:December 1 2009 11:17am
Subject:RE: Innodb buffer pool size filling up
View as plain text  
The size was at 2Gb and was recently changed to 3Gb in size during the last
week of November (around the 23rd / 24th) and as of this morning was already
sitting at 2.3gb used. 

 

The total database size is about 750Mb.

 

Regards

Machiel

 

 

From: Claudio Nanni [mailto:claudio.nanni@stripped] 
Sent: 01 December 2009 01:12 PM
To: machiel.richards
Cc: mysql@stripped
Subject: Re: Innodb buffer pool size filling up

 

That is basically its use,
the buffer pool is the collection of all mysql innodb buffers, 
and after warm up it goes to keep all cacheable data.
How big is your  INNODB_BUFFER_POOL_SIZE ?

Cheers

Claudio



2009/12/1 machiel.richards <machiel.richards@stripped>

There are no errors in the logs at all.

       We have a script to calculate the percentages used and free in order
to do daily,weekly and monthly reporting trend analyses and thus we notice
the growth but no errors.




-----Original Message-----
From: Neil Aggarwal [mailto:neil@stripped]
Sent: 01 December 2009 08:55 AM
To: mysql@stripped
Subject: RE: Innodb buffer pool size filling up

Machiel:

>                 We have a MySQL database where the
> INNODB_BUFFER_POOL_SIZE
> keeps on filling up.

Are you getting any errors or just noticing the buffer
pool is full?

I saw some error messages about the buffer pool size
becoming a problem if the fscync is slow.  Do you see
any more info in the logs?

       Neil

--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
Host your MySQL database on a CentOS VPS for $25/mo
Unmetered bandwidth = no overage charges, 7 day free trial


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

http://lists.mysql.com/mysql?unsub=1



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1




-- 
Claudio


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