On Tue, 27 Feb 2001, Markus H. Maussner wrote:
> does anybody know the limitations of mysql ? i am planing to make a
> big database. with big i mean something like 1,5TB ... the hardware
> seems not to be the problem (we get a big RAID for that, and our
> sysadmin sais that our linux system can take that much hdd space (told
> me something of a special kernel))..
Markus,
a quote from the very fine manual:
How Big MySQL Tables Can Be
===========================
*MySQL* Version 3.22 has a 4G limit on table size. With the new
`MyISAM' in *MySQL* Version 3.23 the maximum table size is pushed up to
8 million terabytes (2 ^ 63 bytes).
Note, however, that operating systems have their own file size limits.
Here are some examples:
*Operating System* *File Size Limit*
Linux-Intel 32 bit 2G, 4G or bigger depending on Linux
version
Linux-Alpha 8T (?)
Solaris 2.5.1 2G (possible 4G with patch)
Solaris 2.6 4G
Solaris 2.7 Intel 4G
Solaris 2.7 ULTRA-SPARC 8T (?)
On Linux 2.2 you can get bigger tables than 2G by using the LFS patch
for the ext2 file system. On Linux 2.4 there exists also patches for
ReiserFS to get support for big files.
<snip>
You can go around the operating system file limit for `MyISAM' data
files by using the `RAID' option. *Note CREATE TABLE::.
-- end of quote ---
Big tables have been discussed frequently the last few weeks. It might be
worth to dig into the archives.
Thomas
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
