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.
2010 9:31 AM
To: mysql@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
@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_total
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