List:InnoDB Storage Engine« Previous MessageNext Message »
From:Konstantin K Date:March 4 2010 11:43pm
Subject:innodb ibdata files and sizes
View as plain text  
Hey guys,

How do you recommend I organize my innodb files?
I'm afraid of them getting too big (> 5gb) because then it becomes
hard to deal with them (move them around, store them, etc).

Currently, I have innodb_data_file_path set to this:

innodb_data_file_path =
ibdata1:2G;ibdata2:2G;ibdata3:2G;ibdata4:2G;ibdata5:2G;ibdata6:2G;ibdata7:2G;ibdata8:2G:autoextend

1. Is this reasonable?
2. Can I specify ~ 50 ibdata files? Or will that somehow slow down performance?
3. How do people deal with huge ibdata files?

Thanks
Konstantin
Thread
innodb ibdata files and sizesKonstantin K5 Mar