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
6603
September 08, 2010 10:35PM
2246
September 10, 2010 12:01AM
4466
September 10, 2010 09:44AM
2229
September 10, 2010 09:59AM
2208
September 10, 2010 12:26PM
6628
September 10, 2010 11:14PM
2986
September 14, 2010 08:42AM
2322
September 14, 2010 09:44AM
Re: innodb memory usage vs swap
2283
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.