Limitations of MySQL Database
Limitations of MySQL Database
Many of the Mysql user does not
know the limitations of Mysql database. So here I am writing
some of the Mysql limitations are
as follows.
In mysql database the maximum size
of the table is determined by operating system in which the Mysql is installed.
So the maximum size of table is allowed by the operating system.
Below mentioned table showing the
file size limit of operating systems :
|
Operating
System
|
File
Size Limit
|
|
Windows
(FAT32)
|
4GB
|
|
Windows
(NTFS)
|
2TB
|
|
MacOS
|
2TB
|
|
Linux
|
4TB
|
|
Solaris
9/10
|
16TB
|
Limitations 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. It can also applies
to LEFT and RIGHT OUTER JOINS.
Limitations of the MyISAM storage engine :
Large files up to 63-bit file
length are supported. There is a limitation of 264 (1.8 * 1019)
rows in a MyISAM table. The maximum number of indexes per MyISAM table is 64.
You can also configure the build by invoking configure with the
-with-max-indexes=N option, where N is the maximum number of indexes to permit
per MyISAM table. N must be less than or equal to 128.
The maximum number of columns per
index is 16. The maximum key length is 1000 bytes. It can be changed by
changing the source and recompiling.
Limitations of the InnoDB Storage Engine :
A table cannot contain more than
1000 columns. The internal maximum key length is 3500 bytes, but MySQL itself
restricts this to 1024 bytes.
The maximum row length, except for
VARCHAR, BLOB and TEXT columns, is slightly less than half of a database page.
That is, the maximum row length is about 8000 bytes. LONGBLOB and LONGTEXT
columns must be less than 4GB, and the total row length, including also BLOB
and TEXT columns, must be less than 4GB.
Although InnoDB supports row sizes larger
than 65535 internally, you cannot define a row containing VARCHAR columns with
a combined size larger than 65535.
The maximum tablespace size is 4 Mia database pages
(64TB). This is also the maximum size for a table.
Limitations of Partitions :
The limitation of partitions with
MySQL is 1024 (internal mail). But one have to increase open_files_limit.
Limitations of MySQL Cluster :
Max attributes/columns in an
index: 32
Max number of attributes (columns
and indexes) in a table: 128
Max number of table: 1792 (v5.0).
Max size in bytes of a row is 8052
byte, excluding blobs which are stored separately.
Max number of nodes in a cluster:
63, max. number of data nodes: 48 (in v5.0/5.1)
Max number of nodes in a cluster:
255 in CGE.
Max number of metadata objects:
20320.
Max attribute name length: 31
characters.
Max database + table name length:
122 characters.
Comments
Post a Comment