Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Support #226447
I am experiencing an unexpected table size limitation with our compressed InnoDB table. My configuration uses a 16K innodb_page_size, and based on MariaDB documentation, I expected to be able to grow tables up to 64TB. However, I am hitting a hard limit at 32TB. For this table the row_format=compressed & zip_page_size=8k.
Environment:
innodb_page_size: 16K
Table compression: Enabled (ROW_FORMAT=COMPRESSED)
Current compressed table size: 32TB = 35184372088832
Expected maximum table size: 64TB (per documentation for 16K innodb page size)
I rebuilt the table without compression (row_format=dynamic), and the new ibd file size is now 38TB.
Issue: My production table has reached approximately 32TB in compressed size and cannot grow beyond this point. According to MariaDB documentation, with a 16K page size, the maximum table size should be 64TB.
Confirmed: The table size limit is effectively ZIP_PAGE_SIZE * (2*32 - 1) instead of innodb_page_size * (2*32 - 1) when using the compressed row format.