That's not that big... But you probably should consider using the
innodb file per table setting. That will probably give you some better
slices, but it depends on your data.
HTH,
Andrew
On Mar 4, 2010, at 6:42 PM, Konstantin K <[email protected]> wrote:
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
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
