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
Subject
Views
Written By
Posted
7636
September 08, 2010 10:35PM
2688
September 10, 2010 12:01AM
5551
September 10, 2010 09:44AM
2800
September 10, 2010 09:59AM
2779
September 10, 2010 12:26PM
9362
September 10, 2010 11:14PM
3750
September 14, 2010 08:42AM
Re: innodb memory usage vs swap
2931
September 14, 2010 09:44AM
2870
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.