好像没有满的概念,除非你的硬盘满了。不过在大容量的数据面前,mysql的性能会下降,慢点。如果那样的话,用oracle啦。要测试数据的话,到网上找一些数据库的比较资料。
解决方案 »
- 求高手帮忙mysql 1064错误,小弟感激不尽!
- java程序连接mysq数据库l出问题,请求帮助。
- mysql是否支持prepareStatement
- mysql 触发器问题2
- 关于MYSQL中插入新记录的问题
- 求助:學生成績排名的列表SQL語句
- 我把本地计算机中的数据库备份出来,然后想在另一台计算机上把它还原进去,不过,前后两台计算机的机器名不一样,这会影响备份文件的导入吗?
- mysql查询中出问题
- 如何检测mysql句柄的有效性
- 遇到一个问题,在网上搜没找到合适的,想来这里问问看有没有大神给解决下
- 俺WINNT上安装了MySql3.23用NET START MySql启动后,键入mysqlshow,显示错误。
- 问大家一个很菜的问题,mysql -h后面添什么,127.0.0.1还是计算机名
(据说,没有实地测试)
1.2.4 How Big Can MySQL Tables Be?
MySQL Version 3.22 has a 4G limit on table size. With the new MyISAM table type in
MySQL Version 3.23, the maximum table size is pushed up to 8 million terabytes (2 ^ 63
bytes).
Chapter 1: General Information About MySQL 9
Note, however, that operating systems have their own le 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
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 le
system. On Linux 2.4 there exists also patches for ReiserFS to get support for big les.
This means that the table size for MySQL is normally limited by the operating system.
By default, MySQL tables have a maximum size of about 4G. You can check the maximum
table size for a table with the SHOW TABLE STATUS command or with the myisamchk -dv
table_name. See Section 4.5.5 [SHOW], page 229.
If you need bigger tables than 4G (and your operating system supports this), you should
set the AVG_ROW_LENGTH and MAX_ROWS parameter when you create your table. See Section
6.5.3 [CREATE TABLE], page 420. You can also set these later with ALTER TABLE.
See Section 6.5.4 [ALTER TABLE], page 428.
If your big table is going to be read-only, you could use myisampack to merge and compress
many tables to one. myisampack usually compresses a table by at least 50%, so you can
have, in eect, much bigger tables. See Section 4.7.4 [myisampack], page 254.
You can go around the operating system le limit for MyISAM data les by using the RAID
option. See Section 6.5.3 [CREATE TABLE], page 420.
Another solution can be the included MERGE library, which allows you to handle a collection
of identical tables as one. See Section 7.2 [MERGE], page 448.
需要注意的是,如果你的文件系统支持超过2G的文件
If you need bigger tables than 4G (and your operating system supports this), you should
set the AVG_ROW_LENGTH and MAX_ROWS parameter when you create your table. See Section
6.5.3 [CREATE TABLE], page 420. You can also set these later with ALTER TABLE.
See Section 6.5.4 [ALTER TABLE], page 428.还有关于并发访问,并发放问小于100数据量小于10G都没什么根据,至少我接触过得很多都已经远远超过了这个范围。