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 in
hards
> TO: mysql@lists.mysql.com
> SENT: Thu, May 20, 2010 1:07:43 PM
> SUBJECT: Innodb buffer pool size
>
> Hi Guys
>
> I just have a quick question.
>
> I have done some research into how to determine the size of your Innodb
> buffer pool.
>
> Al
Hope that helps!
Regards,
Nitin
From: Machiel Richards
To: mysql@lists.mysql.com
Sent: Thu, May 20, 2010 1:07:43 PM
Subject: Innodb buffer pool size
Hi Guys
I just have a quick question.
I have done some research into how to determine the si
Hi Guys
I just have a quick question.
I have done some research into how to determine the size of your Innodb
buffer pool.
All of the sources I used, specified that the Innodb buffer pool size
should be the same size as your database + 10%.
However, as far as I
>-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
Здравствуйте, .
Hi all. I try to increaseinnodb_buffer_pool_size
There is log file:
mysqld_safe[23845]: started
mysqld[23848]: 060615 19:14:52 InnoDB: Error: cannot allocate 2147500032 bytes
of
mysqld[23848]: InnoDB: memory with malloc! Total allocated memory
mysqld[23848]: InnoDB: by Inno
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
t: Monday, May 16, 2005 2:18 PM
> To: Mysql List (E-mail)
> Subject: innodb buffer pool size question
>
> Hi all,
>
> I set the innodb_buffer_pool_size=1024M in my.cnf
>
> show variables returns
>
> .
> innodb_buffer_pool_size | 1073741
Hi all,
I set the innodb_buffer_pool_size=1024M in my.cnf
show variables returns
.
innodb_buffer_pool_size | 1073741824
show innodb status returns
--
BUFFER POOL AND MEMORY
--
Total memory allocated 1169691576; in additional p
I read in a couple of places that on a dedicated server the innodb buffer pool size
should not exceed 70% of total physical memory. Where does this number come from?
Thanks in advance,
Sergei
21 matches
Mail list logo
