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
7572
September 08, 2010 10:35PM
2670
September 10, 2010 12:01AM
5469
September 10, 2010 09:44AM
2771
September 10, 2010 09:59AM
2753
September 10, 2010 12:26PM
9276
September 10, 2010 11:14PM
3713
September 14, 2010 08:42AM
2912
September 14, 2010 09:44AM
Re: innodb memory usage vs swap
2846
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.