List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:December 1 2009 8:04pm
Subject:RE: Innodb buffer pool size filling up
View as plain text  
>-----Original Message-----
>From: machiel.richards [mailto:machiel.richards@stripped]
>Sent: Tuesday, December 01, 2009 6:17 AM
>To: 'Claudio Nanni'
>Cc: mysql@stripped
>Subject: RE: Innodb buffer pool size filling up
>
>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.
>
>
[JS] At the others have said, the whole purpose of a buffer pool is to hold as 
much frequently used data as possible. That lowers the probability of having 
to do physical I/O, which is much slower than memory access. The buffer pool 
should be full.
>
>The total database size is about 750Mb.
>
>
[JS] It does surprise me that the buffer pool fills up, even though it is 
three times the size of your database. My guess is that whatever mechanism is 
used to "scavenge" space in the buffer pool isn't triggered until the buffer 
pool is full; but that is simply a guess, I really have no idea.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com



>
>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