MySQL Forums
Forum List  »  InnoDB

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
6484
September 08, 2010 10:35PM
2169
September 10, 2010 12:01AM
4349
September 10, 2010 09:44AM
2166
September 10, 2010 09:59AM
2158
September 10, 2010 12:26PM
6333
September 10, 2010 11:14PM
2910
September 14, 2010 08:42AM
2251
September 14, 2010 09:44AM
Re: innodb memory usage vs swap
2226
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.