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
