Re: RE: Innodb buffer pool size filling up

2009-12-18 Thread Claudio Nanni
Machiel, That is how it is supposed to work. You assign a certain amount of memory(RAM) to it and the database engine then manages it. It is highly desirable that this buffer is fully used, and if the growing curve is slow it is because it is not undersized. If you really need more ram for other

RE: RE: Innodb buffer pool size filling up

2009-12-18 Thread machiel.richards
Thank you very much. This now explains a lot. From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: 18 December 2009 10:05 AM To: machiel.richards Cc: mysql@lists.mysql.com Subject: Re: RE: Innodb buffer pool size filling up Machiel, That is how it is supposed

RE: Innodb buffer pool size filling up

2009-12-18 Thread Jerry Schwartz
-Original Message- From: machiel.richards [mailto:machiel.richa...@gmail.com] Sent: Friday, December 18, 2009 12:33 AM To: mysql@lists.mysql.com Subject: RE: Innodb buffer pool size filling up Good Morning all QUOTE: We have a MySQL database where

RE: Innodb buffer pool size filling up

2009-12-17 Thread machiel.richards
. Regards Machiel -Original Message- From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com] Sent: 01 December 2009 10:04 PM To: 'machiel.richards'; 'Claudio Nanni' Cc: mysql@lists.mysql.com Subject: RE: Innodb buffer pool size filling up -Original Message- From

Re: Innodb buffer pool size filling up

2009-12-01 Thread Claudio Nanni
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

RE: Innodb buffer pool size filling up

2009-12-01 Thread machiel.richards
...@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

Re: Innodb buffer pool size filling up

2009-12-01 Thread Claudio Nanni
...@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

RE: Innodb buffer pool size filling up

2009-12-01 Thread Jerry Schwartz
-Original Message- From: machiel.richards [mailto:machiel.richa...@gmail.com] Sent: Tuesday, December 01, 2009 6:17 AM To: 'Claudio Nanni' Cc: mysql@lists.mysql.com Subject: RE: Innodb buffer pool size filling up The size was at 2Gb and was recently changed to 3Gb in size during the last

RE: Innodb buffer pool size filling up

2009-11-30 Thread Neil Aggarwal
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

RE: Innodb buffer pool size filling up

2009-11-30 Thread machiel.richards
...@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