Some limitations of MySQL 5.6

Limits in MySQL 5.6Sql Join limit:

<=61 (for tables that the view can refer to)

Database and number of tables limits:

The table size of the MySQL database is generally determined by the single file size limit of the operating system and is not determined by the MySQL kernel;

Common OS Machine File size limitations:

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
OS X w/hfs+	2TB

The INNODB storage engine maintains the innodbtables through Tablespace, while the tablespace can have multiple data files, which can use raw disk partitions. The maximum table space can reach 64TB; in other words, when using the InnoDB engine, his database table can reach 64T;

How to expand the Innodbtablespace space:

Mysql manual reference:section14.4.2, "changing the number or Size of InnoDB Log Files"

Limits on Table Column Count and Row Size

4096 columns per table

A maximum row size of 65,535 bytes

InnoDB permits up to columns.

? InnoDB restricts row size to something less than half a databasepage (approximately 8000

bytes), not including VARBINARY, Varchar,blob, or TEXT columns

InnoDBpermits up to 4 billion tables. from MySQL 5,.5

Some limitations of MySQL 5.6