Re: innodb memory usage vs swap

[kevin foote]

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