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

Allow > 16K pages on InnoDB

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.0
    • None

    Description

      Currently maximum page size inside InnoDB is 16K. This is problematic especially if you have a lot of blob objects because at least part of the blob is always stored on single page and only ther remainder externally stored. This leads to situation where you can have only limited amount of columns as blobs.

      Therefore, plan is

      1) Increase the supported page size to 64K for COMPACT row format
      2) Research if same can be supported for DYNAMIC row format

      Currently, I do not have plans to support > 16K pages on COMPRESSED row format.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11828 innodb_page_size=64k must reject ROW_FORMAT=REDUNDANT records longer than 16383 bytes

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19016 Table in InnoDB data dictionary contains invalid flags upon undo-upgrade from 10.1.8

          • Major - Major loss of function.
          • Closed

          Activity

            jplindst Jan Lindström (Inactive) added a comment -

            revno: 3987
            committer: Jan Lindström <jplindst@mariadb.org>
            branch nick: 10.1
            timestamp: Tue 2014-05-13 13:28:57 +0300
            message:
            MDEV-6075: Allow > 16K pages on InnoDB

            This patch allows up to 64K pages for tables with DYNAMIC, COMPACT
            and REDUNDANT row types. Tables with COMPRESSED row type allows
            still only <= 16K page size. Note that single row size must be
            still <= 16K and max key length is not affected.

            jplindst Jan Lindström (Inactive) added a comment - revno: 3987 committer: Jan Lindström <jplindst@mariadb.org> branch nick: 10.1 timestamp: Tue 2014-05-13 13:28:57 +0300 message: MDEV-6075 : Allow > 16K pages on InnoDB This patch allows up to 64K pages for tables with DYNAMIC, COMPACT and REDUNDANT row types. Tables with COMPRESSED row type allows still only <= 16K page size. Note that single row size must be still <= 16K and max key length is not affected.

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              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.