1.2.4 How Big Can MySQL Tables Be?MySQL Version 3.22 had a 4G limit on table size. With the MyISAM table type in MySQL Version 3.23, the maximum table size was pushed up to 8 million terabytes (2 ^ 63 bytes). 注(1 terabyte = 1000 GB)!!!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 more, depends on Linux version | Linux-Alpha | 8T (?) | Solaris 2.5.1 | 2G (possible 4G with patch) | Solaris 2.6 | 4G (can be changed with flag) | Solaris 2.7 Intel | 4G | Solaris 2.7 UltraSPARC | 512G +--------------------------+-------------------------------------------
使用 InnoDB 表,就可以支持外键约束,使用事务处理了,
更详细地请查看 MySQL 参考手册
主机是C1.7 128 20G/7200r +win98 +mysql 4.014
所有的查询到可以在可以忍受的时间内完成,顺便提一下,一次查询返回的记录数
不能超过1000000条
+--------------------------+-------------------------------------------
| Operating System | File-Size Limit
+--------------------------+-------------------------------------------
| Linux-Intel 32 bit | 2G, 4G or more, depends on Linux version
| Linux-Alpha | 8T (?)
| Solaris 2.5.1 | 2G (possible 4G with patch)
| Solaris 2.6 | 4G (can be changed with flag)
| Solaris 2.7 Intel | 4G
| Solaris 2.7 UltraSPARC | 512G
+--------------------------+-------------------------------------------
是用五笔打的字,
出现了好些笔误:(这里应该是:
一个表的最大容量是 4G !!:)呵呵,
正好提到这人问题了,
我再加一句吧,对于有没有办法限止一个 MyISAM 表最大容量,
有很多朋友曾经问过。
MySQL 是这样来处理的,依赖磁盘操作系统的功能来实现,对于 WINNT 系统,
你需要将 MySQL 安装在 NTFS 格式的磁盘分区中,
然后 在建表(CREATE TABLE)时,加上 table_options:
max_rows 和 avg_row_length 就可以了,
avg_row_length 是针对于有变长字段的表