mysql - AWS Aurora 是否受到与 MySQL 相同的限制？

Question

具体来说，MySQL 的最大行大小限制为 64kB。
我想知道 Amazon Aurora(据称是 MySQL 的替代品)是否具有相同的限制。

Answer 1

好吧，根据 AWS 的文档:

The Amazon Aurora database engine is designed to be wire-compatible with MySQL 5.6 using the InnoDB storage engine.

http://aws.amazon.com/rds/aurora/faqs/#general

这意味着 innoDB 限制适用: http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html

专门针对行大小的默认限制是 8000B:

The maximum row length, except for variable-length columns (VARBINARY, VARCHAR, BLOB and TEXT), is slightly less than half of a database page. That is, the maximum row length is about 8000 bytes for the default page size of 16KB; if you reduce the page size by specifying the innodb_page_size option when creating the MySQL instance, the maximum row length is 4000 bytes for 8KB pages and 2000 bytes for 4KB pages. LONGBLOB and LONGTEXT columns must be less than 4GB, and the total row length, including BLOB and TEXT columns, must be less than 4GB.