E.10. Limits in MySQL
This section lists current limits in MySQL 5.6.
E.10.1. Limits of Joins
The maximum number of tables that can be referenced in a single join is 61. This also applies to the
number of tables that can be referenced in the definition of a view.
E.10.2. Limits on Number of Databases and Tables
MySQL has no limit on the number of databases. The underlying file system may have a limit on the
number of directories.
MySQL has no limit on the number of tables. The underlying file system may have a limit on the number
of files that represent tables. Individual storage engines may impose engine-specific constraints. InnoDB
permits up to 4 billion tables.
E.10.3. Limits on Table Size
The effective maximum table size for MySQL databases is usually determined by operating system
constraints on file sizes, not by MySQL internal limits.
To change the default size limit for MyISAM tables, set the myisam_data_pointer_size, which sets the number of bytes
used for internal row pointers. The value is used to set the pointer size for new tables if you do not specify the MAX_ROWS op-
tion. The value of myisam_data_pointer_size can be from 2 to 7. A value of 4 permits tables up to 4GB; a value of 6
permits tables up to 256TB
操作系统 | 文件大小限制 |
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(可能更大) |
MacOS X w/ HFS+ | 2TB |
kider 发表于 2014-3-7 15:45
这篇帖子写的挺好,摘抄过来,归纳总结,以作参考:
http://blog.csdn.net/oraclej/article/details/77459 ...
欢迎光临 MySQL社区 (http://www.mysqlpub.com/) | Powered by Discuz! X3.2 |