Re: Optimal InnoDB datafile size? 150GB data.

[Kurt Haegeman]

Jesper Krogh wrote:

Hi.

I need some recommadations. 

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.
Of the 150GB is about 100GB BlOB's, would it have any impact on the
overall speed of the database to store this data in the filesystem
instead? 

Thanks. 

 

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.

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).

Greetings,
Kurt Haegeman
Mediargus.be
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]