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
7162
September 08, 2010 10:35PM
2472
September 10, 2010 12:01AM
4991
September 10, 2010 09:44AM
2523
September 10, 2010 09:59AM
2502
September 10, 2010 12:26PM
8105
September 10, 2010 11:14PM
3381
September 14, 2010 08:42AM
2645
September 14, 2010 09:44AM
Re: innodb memory usage vs swap
2580
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.