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

Clean up INFORMATION_SCHEMA.INNODB_ tables

Details

    Description

      Let us clean up several inconsistencies and inefficiencies in the INFORMATION_SCHEMA table plugins of InnoDB:

      • For Boolean attributes, use INT(1) NOT NULL instead of VARCHAR containing strings like 'NO','YES','disabled','enabled','Uninitialized','Initialized'.
      • For 32-bit integer attributes, use INT instead of BIGINT.
      • For n-ary attributes, use ENUM instead of VARCHAR.
      • Remove the unnecessary column SYS_TABLESPACES.SPACE_TYPE.
      • Shorten many string columns to more reasonable length. Index and column names can be up to NAME_CHAR_LEN (64) characters long.

      Also, implement some functional changes, such as reducing the memory usage for i_s_locks_row_t and i_s_trx_row_t, and replacing some function calls with inlined code.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21537 InnoDB INFORMATION_SCHEMA tables fail to define DEFAULT for ENUM NOT NULL

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22206 Assertion "heap_no == ULINT_UNDEFINED" in trx0i_s.cc

          • Major - Major loss of function.
          • Closed
          is blocked by

          Task - A task that needs to be done. MDEV-19861 Add intfastructure to have ENUM columns in INFORMATION_SCHEMA

          • Major - Major loss of function.
          • Closed

          Activity

            danblack Daniel Black added a comment -

            VARCHAR strings were ugly, but changing names does break things https://github.com/FromDual/mariadb-sys/pull/1
            Lets see if https://github.com/FromDual/mariadb-sys/pull/2 is successful.

            danblack Daniel Black added a comment - VARCHAR strings were ugly, but changing names does break things https://github.com/FromDual/mariadb-sys/pull/1 Lets see if https://github.com/FromDual/mariadb-sys/pull/2 is successful.

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.