![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461963009.webp)
Limits on Table Size
2989
MySQL has no limit on the number of databases. The underlying file system may have a limit on the
number of tables. Individual storage engines may impose engine-specific constraints.
InnoDB
permits
up to 4 billion tables.
E.7.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. The following table lists some examples of
operating system file-size limits. This is only a rough guide and is not intended to be definitive. For the
most up-to-date information, be sure to check the documentation specific to your operating system.
Operating System
File-size Limit
Win32 w/ FAT/FAT32
2GB/4GB
Win32 w/ NTFS
2TB (possibly larger)
Linux 2.2-Intel 32-bit
2GB (LFS: 4GB)
Linux 2.4+
(using ext3 file system) 4TB
Solaris 9/10
16TB
MacOS X w/ HFS+
2TB
NetWare w/NSS file system
8TB
Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production
use with MySQL. Use NTFS instead.
On Linux 2.2, you can get
MyISAM
tables larger than 2GB in size by using the Large File Support (LFS)
patch for the ext2 file system. Most current Linux distributions are based on kernel 2.4 or higher and
include all the required LFS patches. On Linux 2.4, patches also exist for ReiserFS to get support for
big files (up to 2TB). With JFS and XFS, petabyte and larger files are possible on Linux.
For a detailed overview about LFS in Linux, have a look at Andreas Jaeger's Large File Support in
Linux page at
http://www.suse.de/~aj/linux_lfs.html
.
If you do encounter a full-table error, there are several reasons why it might have occurred:
• The disk might be full.
• The
InnoDB
storage engine maintains
InnoDB
tables within a tablespace that can be created from
several files. This enables a table to exceed the maximum individual file size. The tablespace can
include raw disk partitions, which permits extremely large tables. The maximum tablespace size is
64TB.
If you are using
InnoDB
tables and run out of room in the
InnoDB
tablespace. In this case, the
solution is to extend the
InnoDB
tablespace. See
Section 14.2.4, “Adding, Removing, or Resizing
InnoDB
Data and Log Files”
.
• You are using
MyISAM
tables on an operating system that supports files only up to 2GB in size and
you have hit this limit for the data file or index file.
• You are using a
MyISAM
table and the space required for the table exceeds what is permitted by
the internal pointer size.
MyISAM
creates data and index table files to permit up to 4GB by default
(256TB as of MySQL 5.0.6), but this limit can be changed up to the maximum permissible size of
65,536TB (256
7
– 1 bytes).
If you need a
MyISAM
table that is larger than the default limit and your operating system supports
large files, the
CREATE TABLE
statement supports
AVG_ROW_LENGTH
and
MAX_ROWS
options. See
Section 13.1.10, “
CREATE TABLE
Syntax”
. The server uses these options to determine how large a
table to permit.
If the pointer size is too small for an existing table, you can change the options with
ALTER TABLE
to
increase a table's maximum permissible size. See
Section 13.1.4, “
ALTER TABLE
Syntax”
.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...