Limit ของ Table ใน MySQL

[doramon]

Limit ของ Table ใน MySQL

Linux 2.2-Intel 32-bit -------------------------------->2GB (LFS: 4GB)
Linux 2.4+ (using ext3 filesystem) ------------->4TB
Solaris 9/10 ------------------------------------------->16TB
NetWare w/NSS filesystem -------------------->8TB
Win32 w/ FAT/FAT32 ----------------------------->2GB/4GB
Win32 w/ NTFS -------------------------------------->2TB (possibly larger)
MacOS X w/ HFS+ ---------------------------------->2TB

Limit ของ FoxPro (จาก อ. FoxForU)
Maximum # of records per table file. 1 billion
Maximum size of a table file. 2 gigabytes
Maximum size of an FPT file. 2 gigabytes
Maximum # of characters per record. 65,500
Maximum # of fields per record1. 255
Maximum # of tables open at one time2. 65,535
Maximum # of characters per table field. 254
Maximum # of bytes per index key in a non-compact index3. 100
Maximum # of bytes per index key in a compact index3. 240
Maximum # of open index files per table2. Limited by available memory
Maximum # of open indexes in all work areas2. Limited by available memory
Maximum # of relations. Limited by available memory
Maximum length of relational expressions. Limited by available memory