MySQL Limitaions

Posted: January 14, 2013 in MySQL
Tags: ,

GENERAL LIMITATIONS OF MYSQL

 

32-bit binaries cannot address more than 4 Gbyte of memory. This is not a MySQL limitation, this is a technical limitation.

BLOB‘s are limited to 1 Gbyte in size even thought you use LONGBLOB because of a limitation in the MySQL protocol: The protocol limit for max_allowed_packet is 1GB.

 


LIMITATIONS OF MYSQL 4.1

Limitations of Joins

In MySQL 4.1, 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. 

Limitations of the MyISAM storage engine

There is a limitation of 232 (~4.2 Mia) rows in a MyISAM table. You can increase this limitation if you build MySQL with the –with-big-tables option then the row limitation is increased to 264 (1.8 * 1019) rows.

 


LIMITATIONS OF MYSQL 5.0

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. This 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 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. This 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 VARCHARBLOB 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 4 Gbyte, and the total row length, including also BLOB and TEXT columns, must be less than 4 Gbyte.

Although InnoDB supports row sizes larger than 65535 internally, you cannot define a row containing VARCHARcolumns with a combined size larger than 65535.

The maximum tablespace size is 4 Mia database pages (64 Tbyte). This is also the maximum size for a table.

 


LIMITATIONS OF MYSQL 5.1

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. 

Limitations of Partitions

The limitation of partitions with MySQL is 1024 (internal mail). But one have to increase open_files_limit. See also: [Lit.]

 


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.

 

Ref & Source: http://www.fromdual.ch

Advertisements
Comments
  1. people finder illinois says:

    Really evident web site , thanks for this post.

  2. reverse phone lookup reverse phone lookup says:

    your blog is very fine. It was very well authored and straightforward to
    understand. Unlike additional online pages I have read which have been actually not good.
    I also found your posts very interesting

  3. Customer Satisfaction enhanced with B2B Live Chat says:

    Greate pieces. Keep posting such kind of information on your blog.
    Im really impressed by your site.
    Hey there, You have performed an excellent job. I will certainly digg it and for my
    part suggest to my friends. I am sure they will be benefited from this web site.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s