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
6555
September 08, 2010 10:35PM
2207
September 10, 2010 12:01AM
4403
September 10, 2010 09:44AM
2197
September 10, 2010 09:59AM
2180
September 10, 2010 12:26PM
6463
September 10, 2010 11:14PM
2956
September 14, 2010 08:42AM
Re: innodb memory usage vs swap
2294
September 14, 2010 09:44AM
2257
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.