<=61(適用於視圖所能引用的表)
Mysql 數據庫的表(table)大小一般由操作系統單個文件大小限制決定,並不是由mysql 內核決定;
常見os機器文件大小限制:
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
Innodb 存儲引擎通過tablespace 來維護innodbtables;而表空間可以有多個數據文件,這些表空間可以使用raw disk partitions。而表空間最大可以達到64TB;那麼換句話說在使用innodb引擎時,他的數據庫表可以達到64T;
如何擴張innodbtablespace 空間:
Mysql manual reference:Section14.4.2, “Changing the Number or Size of InnoDB Log Files”
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 databasepage (approximately 8000
bytes), not including VARBINARY, VARCHAR,BLOB, or TEXT columns
InnoDB permits up to 4 billion tables. From mysql 5,.5