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.richa...@gmail.com> > 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.na...@gmail.com] > *Sent:* 01 December 2009 01:12 PM > *To:* machiel.richards > *Cc:* mysql@lists.mysql.com > *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.richa...@gmail.com> > > 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:n...@jammconsulting.com] > Sent: 01 December 2009 08:55 AM > To: mysql@lists.mysql.com > 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=machiel.richa...@gmail.com > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com > > > > > -- > Claudio > -- Claudio
