Mysql 5.6 and mysql5.6

Mysql 5.6 and mysql5.6
Limits in MySQL 5.6Sql Join restrictions:

<= 61 (applicable to tables that can be referenced by a view)

 

Database and table quantity limit:

The table size of a Mysql database is generally determined by the size limit of a single file in the operating system, not by the mysql kernel;

File size limit for common OS machines:

Operating System	File-size Limit
Win32 w/FAT/FAT32	2 GB/4 GB
Win32 w/NTFS	2 TB (possibly larger)
Windows 2.2-Intel 32-bit	2 GB (LFS: 4 GB)
Linux 2.4 +	(Using ext3 file system) 4 TB
Solaris 9/10	16 TB
OS X w/HFS +	2 TB

 

The Innodb Storage engine maintains innodbtables through tablespace, while the tablespace can have multiple data files which can use raw disk partitions.The maximum table space can be 64 TB. In other words, when the innodb engine is used, its database table can be 64 TB;

 

How to expand innodbtablespace:

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 1000 columns.

• InnoDB restricts row size to something less than half a database Age (approximately 8000

Bytes), not including VARBINARY, VARCHAR, BLOB, or TEXT columns

 InnoDBPermits up to 4 billion tables. From mysql 5,. 5