MySQL Forums
Forum List  »  InnoDB

Re: innodb memory usage vs swap
Posted by: kevin foote
Date: September 14, 2010 09:44AM

One more novice / dumb question on this.

My innodb files look like this ...

#> ls -lh /var/lib/mysql/ibdata*
/var/lib/mysql/ibdata:
total 14G
-rw-rw---- 1 mysql mysql 14G Sep 14 11:39 ib_data1

/var/lib/mysql/ibdata_logs:
total 513M
-rw-rw---- 1 mysql mysql 256M Sep 14 11:39 ib_logfile0
-rw-rw---- 1 mysql mysql 256M Sep 14 11:08 ib_logfile1


Do I want the entire ib_data1 (innodb tablespace) file to fit into memory? If so I need to/ should have put the max:XG setting there during config..

What are the impacts, if any, of putting a max on the inno tablespace file?

- kevin

Options: ReplyQuote


Subject
Views
Written By
Posted
6506
September 08, 2010 10:35PM
2184
September 10, 2010 12:01AM
4365
September 10, 2010 09:44AM
2178
September 10, 2010 09:59AM
2167
September 10, 2010 12:26PM
6374
September 10, 2010 11:14PM
2928
September 14, 2010 08:42AM
Re: innodb memory usage vs swap
2265
September 14, 2010 09:44AM
2237
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.