----- Original Message -----
> From: "Adarsh Sharma" <adarsh.sharma@stripped>
> Johan De Meersman wrote:
> A Heartiest Thanks from my heart for explaining all these things in a
> fantastic manner. I agreed with your suggestions but one thing which
> isn't explained from your side , as you go deeper in RAID point.
> Q:- What is your recommendations for number of ibdata files , would
> it be
> Make sure the disk /hdd2-1/innodb_data1 is big enough and it doesn't
> affect performance.
Roughly, yes - file-per-table is only useful if you need to be able to reclaim the space
for non-InnoDB data; and I don't think InnoDB stripes across datafiles, so just use one
large file on one RAID partition. Saves on file descriptors, saves on header space.
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel