List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:December 1 2009 11:23am
Subject:Re: Innodb buffer pool size filling up
View as plain text  
The Innodb Buffer Pull usually follow a growth over time that resembles an
horizontal asintot (
http://www.maecla.it/bibliotecaMatematica/go_file/MONE_BESA/grafico.gif)
This to leverage all its size!
So should not be a problem!

Cheers

Claudio


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

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



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