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

Allow > 16K pages on InnoDB

        Details

        • Type: Task
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Fix Version/s: 10.1.0
        • Component/s: None
        • Labels:

          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.

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                jplindst Jan Lindström 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.

                Show
                jplindst Jan Lindström 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

                  • Assignee:
                    jplindst Jan Lindström
                    Reporter:
                    jplindst Jan Lindström
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 1 week, 3 days
                      1w 3d