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:[email protected]] Sent: 01 December 2009 01:12 PM To: machiel.richards Cc: [email protected] 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 <[email protected]> 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:[email protected]] Sent: 01 December 2009 08:55 AM To: [email protected] 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/[email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected] -- Claudio
