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

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 to

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 us

RE: Innodb buffer pool size filling up

2009-12-17 Thread machiel.richards
yone in advance. 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

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 rece

Re: Innodb buffer pool size filling up

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

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

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

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 mor