Re: innodb memory usage vs swap
Posted by:
Rick James
Date: September 14, 2010 08:12PM
> What are the impacts, if any, of putting a max on the inno tablespace file?
You will crash.
Let InnoDb do its thing. It will cache what it needs of ibdata1 in the buffer_pool. Free spots in ibdata1 won't be cached. Inactive blocks won't need to be cached. Etc.
Sure, it would be nice if you had enough RAM for a buffer pool big enough for all your data (and indexes). But if you don't, ibdata1 will grow, and the buffer pool caching will hide (mostly) that fact that it is not big enough.
Subject
Views
Written By
Posted
7534
September 08, 2010 10:35PM
2650
September 10, 2010 12:01AM
5426
September 10, 2010 09:44AM
2752
September 10, 2010 09:59AM
2734
September 10, 2010 12:26PM
9193
September 10, 2010 11:14PM
3684
September 14, 2010 08:42AM
2890
September 14, 2010 09:44AM
Re: innodb memory usage vs swap
2828
September 14, 2010 08:12PM
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.