From: Johan De Meersman Date: March 16 2011 9:39am Subject: Re: Suggestions for InnoDB files List-Archive: http://lists.mysql.com/mysql/224664 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_c5dc2ed0-d9f8-4a75-a590-22d1574cad8f" --=_c5dc2ed0-d9f8-4a75-a590-22d1574cad8f Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Adarsh Sharma" > 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 --=_c5dc2ed0-d9f8-4a75-a590-22d1574cad8f--