Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38930

Compressed table hits size limit at 50% capacity instead of expected maz table size per innodb page size documentation

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            shreyas.pandey Shreyas Pandey
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.