The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Aria Max Table Size

Aria looks to be a safer robust replacement to MyISAM for data warehousing. However, I was unable to find any mention of maximum table sizes for tables in various row formats. Upon creating tables and getting information in SequelPro, I saw the following:

Aria Dynamic: 4GB
Aria Fixed: 20GB
Aria Page: 64GB

This would seem counterproductive as MyISAM supports 256TB. Is there an official statistic on the maximum amount of data that Aria can handle?

Answer

You need to specify MAX_ROWS when you create a table (MyISAM or Aria). With the default value of MAX_ROWS you will not reach storage engine limits on the table size.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.