Re: When does innodb buffer pool charge for memory?
Posted by:
Rick James
Date: November 20, 2014 06:35PM
I believe, without proof, that InnoDB will grow the buffer pool up to a max of 6GB. So, if you don't 'touch' 6GB of data and indexes (and other overhead), less than 6GB may be "in use" according to the operating system.
If all the active memory in the system exceeds 16GB, the OS will start "swapping". If any of the buffer_pool is swapped, MySQL performance will suffer terribly.
Why do you ask the question?
Subject
Views
Written By
Posted
1766
November 19, 2014 10:21PM
Re: When does innodb buffer pool charge for memory?
1026
November 20, 2014 06:35PM
1258
November 21, 2014 03:42AM
1132
November 22, 2014 12:05PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.