Re: Optimal InnoDB datafile size? 150GB data.

[Kurt Haegeman]

Jesper Krogh wrote:

I gmane.comp.db.mysql.general, skrev Kurt Haegeman:
 

What is the optimal InnoDB datafile size? Is 75 * 2GB prefered over 1 *
1G:autoextend? The filesystem (ext3) has no problems handling the
filesizes, so that should not be an issue.
     

If your one large datafile suffers irrepairable block corruption, you'll 
have to prepare for a restore of a XXX Gb file, which will take much 
longer than replacing a damaged 2Gb datafile. We suffered from such a 
loss on our Oracle database, and since then we no longer use datafiles 
larger than 2Gb.
   

So MySQL dont care wether it's a block of 100GB or several smaller,
regarding speed?
 

Regarding speed: no, MySQL won't run any faster or slower on one large 
datafile compared to several smaller ones. Regarding stability, 
availability, recovery, I'd strongly advice against the use of one 
single extremely large datafile.

Just my two cents, you know. Personal opinion and such.
Kurt Haegeman
Mediargus.be