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? > Concerning your lob question: if the lobs are in often queried tables > with other relational data, and you only use the other data for the > query, then yes, the speed of the database would be better without them > (smaller tables -> more speed). I see. Thanks. -- ./Jesper Krogh, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
