Re: Maximum Database size

2004-03-12 Thread Egor Egorov 
Baum, Stefan [EMAIL PROTECTED] wrote:
 Hi,
 
 I'm planning to use MySQL for logging from an SMTP-Relay. 
 What is the maximum size of the database, that can be reached?
 

Table size (for MyISAM/ISAM tables) and number of tables per database is limited by 
your filesystem.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Maximum Database size

2004-03-12 Thread Thomas Spahni 
Stefan,

it depends ...

For MyISAM tables max size is limited by the maximum filesize of your
OS/Filesystem.

Regards,
Thomas

On Fri, 12 Mar 2004, Baum, Stefan wrote:

  Hi,

  I'm planning to use MySQL for logging from an SMTP-Relay.
  What is the maximum size of the database, that can be reached?

  Stefan


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Maximum Database size

2004-03-12 Thread Alex Greg 
 Stefan,

 it depends ...

 For MyISAM tables max size is limited by the maximum filesize of your
 OS/Filesystem.

Following on from that, the maximum file size you can have on 32-bit Linux is 2GB, 
unless your distro has LFS (Large File Support),
in which case is is much larger (terabytes, not sure exactly how big). I know that 
Fedora Core 1 has LFS, and RedHat Linux 9 might
do as well.

For Windows under NTFS, the file size limit is 2TB, on FAT32 it is 4GB.


-- Alex


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]