Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Does AWS Aurora suffer from the same limitations that MySQL suffer from?

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.

like image 568
Ranjith Ramachandra Avatar asked Sep 28 '22 00:09

Ranjith Ramachandra


1 Answers

Well, according to documentation from 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

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

Specifically for row size default limit is 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.

like image 177
Eckd Avatar answered Oct 05 '22 06:10

Eckd