阅读背景:

AWS Aurora遭受的限制与MySQL相同吗?

来源:互联网 

Specifically, MySQL has a limitations max row size as 64kB.
I would like to know if Amazon Aurora, which is supposedly a drop in replacement for MySQL, shares the same limitation.

特别地,MySQL具有最大行大小为64kB的限制。我想知道亚马逊的Aurora,也就是MySQL的替代品,是否也有同样的局限性。

1 个解决方案

#1


3  

Well, according to documentation from AWS:

根据AWS的文档:

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

Amazon Aurora数据库引擎设计成使用InnoDB存储引擎与MySQL 5.6兼容。

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

https://aws.amazon.com/rds/aurora/faqs/一般

This means that innoDB limits applies: https://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html

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

Specifically for row size default limit is 8000B:

对于行大小的默认限制是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.

除了可变长度列(VARBINARY、VARCHAR、BLOB和TEXT)之外,最大行长度略小于数据库页面的一半。也就是说,默认页面大小为16KB的最大行长度约为8000字节;如果在创建MySQL实例时通过指定innodb_page_size选项来减小页面大小,则最大行长度为8KB页面4000字节,4KB页面2000字节。LONGBLOB和LONGTEXT列必须小于4GB,而包括BLOB和文本列在内的行长度必须小于4GB。


分享到: