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

Popular posts from this blog

How to Bind Multiple SMPP Acounts Using Kannel SMS Gateway.

Hi guys,              Below I have written the script of complete kannel configuration in which I have binded the multiple SMPP accounts with mysql database. Please change your configuration according to your requirement. It is 100 % worked for me and hope it will work for you also. # CORE # # There is only one core group and it sets all basic settings # of the bearerbox (and system). You should take extra notes on # configuration variables like 'store-file' (or 'store-dir'), # 'admin-allow-ip' and 'access.log' group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar dlr-storage = mysql log-file = "/var/log/kannel/kannel.log" access-log = "/var/log/kannel/bearerbox-access.log" access-log-clean = true log-level = 0 box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" # SMSC CONNECTIONS # # SMSC connections are created in bearerbox and they handle SMSC specific # protocol and m...
Read more

Window could not start the Apache tomcat 6 on Local Computer.For more information, review the System Events Logs.If this is a non-Microsoft service,contact service vendor, and refer to service-specific error code 0.

Image
Hi Guys,               Several times we have faced the problem with Apche Tomcat 6 service, It seems fail to start the service of Tomcat Apache and gettting error code 0 even its not work on installation again below is the snapshot of error. So I am writing technique how can we start the Tomcat Apache Services , Just copy one file & paste into Tomcat Apache bin folder please follow the some steps. Follow the below mentioned steps:  1. Copy the file(msvcr71.dll) from location  C:\Program Files\Java\jdk1.6.0_02\bin\  2. Paste the (msvcr71.dll) file into location      C:\Program Files\Apache Software Foundation\Tomcat6.0\bin  3.  After paste start the tomcat service and it will be started and works.  4.  For testing the apache hit the browser with http://localhost:8080/ it display the index page of Apache tomcat it means apache is working fine. ...
Read more

ORACLE DBA INTERVIEW QUESTION & ANSWERS

ORACLE DBA INTERVIEW QUESTION & ANSWERS 1. Which of the following does not affect the size of the SGA. a) Database buffer b) Redo log buffer c) Stored procedure d) Shared pool Answer: c 2. A set of Dictionary tables are created a) Once for the Entire Database b) Every time a user is created c) Every time a Tablespace is created d) None of the above Answer: a 3. The order in which Oracle processes a single SQL statement is ? A. execute, parse, fetch B. execute, fetch, parse C. parse, execute, fetch D. parse, fetch, execute Answer: c 4. What are the mandatory datafiles to create a database in Oracle 11g? A. SYSTEM, SYSAUX B. SYSTEM, USERDATA, TEMP C. SYSTEM, SYSAUX, UNDO Answer: c 5. In one server can we have different oracle versions? A. No B. Yes Answer: b 6. How do sessions communicate with database? A. Server processes use oracle net to connect to the instance. B. Background processes use oracle n...
Read more