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

global option to enable page compression for all new tables

    Details

      Description

      Page compression is transparent for the client accessing the database, but for most existing applications which create tables by themselves, it is inconvenient to implement compression because you must specify whether each table should be compressed at creation. Since an existing application might not support this function and it may create new tables as it runs, it would not use compression at all.

      If the application is written in-house or open source, you could modify the source code to enable compression when creating new tables, but for closed source applications which use MariaDB/MySQL, it is impossible.

      I propose that a global boot variable is created that can be configured in server.cnf to set the default value for all new tables created to compression=1, so that all tables created on the database server can utilize whatever compression the system is configured for.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ratzpo Rasmus Johansson
                Reporter:
                thomasmaerz Thomas Maerz
              • Votes:
                3 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: