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

Page Compression Has No Effect on Table Data File Size

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.2.2, 10.2.3
    • N/A
    • Documentation
    • None
    • Windows 10 Pro 1607 x64, 128GB RAM, i7 6800k MariaDB 10.2.2 Beta

    Description

      Testing zlib page compression and it appears to have no effect on the size of the table data file. To run this test you'll have set tmp_table_size=1G and max_heap_table_size=1G in your my.ini.

      Attachments

        1. MariaDB Table File Sizes.PNG
          16 kB
          Shawn Weeks
        2. Test MariaDB Compression.log
          5 kB
          Shawn Weeks
        3. Test MariaDB Compression.sql
          1 kB
          Shawn Weeks

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15527 page_compressed compressed page partially during import tablespace

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15528 Avoid writing freed InnoDB pages

          • Major - Major loss of function.
          • Closed

          Activity

            People

              greenman Ian Gilfillan
              absolutesantaja Shawn Weeks
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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