[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: ext3 and mySQL Database



Hi,

On Mon, Apr 29, 2002 at 11:54:24AM +0200, Ralf Hildebrandt wrote:
 
> I'm investigating the maximum DB size of mySQL on ext3 with a 2.4
> kernel.
> 
> * mysql is supposed to support tables up to 2^63 bytes
> * kernel-2.4.x supports files up to a size of 16 TB
> 
> But what about the filesystem? What are the limits for the local
> filesystem (ext2, ext3, ReiserFS and XFS) ?

ext2/3 support files up to 4TB by default.  I'm not sure about
reiserfs and XFS, but basically all of these four have the same
practical limit --- you will run into the block device layer's own
limit of 2TB per filesystem before you run into any of the fs file
size limits.

Cheers,
 Stephen





[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]