Ext3 users - Apr 2002 - ext3 and mySQL Database

Hi!

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

-- 
Ralf Hildebrandt (Im Auftrag des Referat V A)   Ralf.Hildebrandt@charite.de
Charite Campus Virchow-Klinikum                 Tel.  +49 (0)30-450 570-155
Referat V A - Kommunikationsnetze -             Fax.  +49 (0)30-450 570-916
"I think there is a world market for maybe five computers."  
 - Thomas Watson, chairman of IBM, 1943.

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