Machiel,
I'm going to disagree strongly with the previous advice you got. You
should NOT configure the buffer pool to be larger than the amount of
RAM you have. If part of the buffer pool is swapped out, then
swapping it back in is MUCH worse than re-fetching the page. InnoDB
doesn't know the d
In infinite wisdom "Machiel Richards" wrote:
> The current Innodb buffer pool size is at 4Gb for instance, and the
> innodb tables then grow to be about 8Gb in size.
InnoDB manages the pool as a list, using a least recently used (LRU) algorithm
incorporating a midpoint insertion strategy. W
Well, my question is specifically related to in the event that the buffer usage
reaches 100%
Quoting Nitin Mehta :
> Hi,
>
> First thing that comes to my mind is that it is probably the best time to put
> your application server and database server on different hosts. Having said
> that, i
Hi,
First thing that comes to my mind is that it is probably the best time to put
your application server and database server on different hosts. Having said
that, in this case increasing buffer pool size is still advisable as per my
understanding. Your swap consumption will go up in that case
>-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
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
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
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
>-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
;
>
>
> *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
...@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
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
...@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
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
Look at this previous thread
http://forums.mysql.com/read.php?22,42721,42721
Kishore Jalleda
http://kjalleda.googlepages.com
On 6/15/06, Vitaliy Okulov <[EMAIL PROTECTED]> wrote:
Здравствуйте, .
Hi all. I try to increaseinnodb_buffer_pool_size
There is log file:
mysqld_safe[23845]: sta
thanks
-Original Message-
From: Partha Dutta [mailto:[EMAIL PROTECTED]
Sent: Monday, May 16, 2005 11:30 AM
To: Sergei Skarupo; 'Mysql List (E-mail)'
Subject: RE: innodb buffer pool size question
The buffer pool size value is in 16K pages (from SHOW INNODB STATUS output)
--
Pa
The buffer pool size value is in 16K pages (from SHOW INNODB STATUS output)
--
Partha Dutta, Senior Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
> -Original Message-
> From: Sergei Skarupo [mailto:[EMAIL PROTECTED]
> Sent: Monday,
17 matches
Mail list logo
