There will be an increase in IO and a noticeable decrease in performance if
the buffer pool is too small. Give it all the memory which is not needed
elsewhere. If you can set it a little larger than the size of all your
innodb tablespaces that would be good.
Oracle is a very different animal to My
@lists.mysql.com
Subject: Re: Innodb buffer pool usage
Hi Machiel,
What do you mean with "innodb buffer pool is at 100% full" ?
There are several status variables associated with innodb buffer pool ie:
Innodb_buffer_pool_pages_free is the number of unused data pages.
Innodb_buffer_pool_pages_to
HI Carlos
We run a script for the monitoring and the output received is as
follows:
InnoDB Buffer Pool __
Usage 3.00G of 3.00G %Used: 100.00
Read hit 100.00%
Pages
Free 0%Total: 0.00
Data
Hi Machiel,
What do you mean with "innodb buffer pool is at 100% full" ?
There are several status variables associated with innodb buffer pool ie:
Innodb_buffer_pool_pages_free is the number of unused data pages.
Innodb_buffer_pool_pages_total is the total number of pages.
Innodb_buffer_pool_
Hi all
Maybe someone can assist me with this one.
A while back I requested some information relating to the
MySQL innodb buffer pool size that seems to fill up rather frequently.
The buffer pool is currently set to 3Gb , and it takes about
2-
