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

Humanize the number of bytes in InnoDB messages

Details

    Description

      For axel for https://github.com/MariaDB/server/pull/1956#issuecomment-984543127

      While we are at it: can we have some diagnostics on buffer pool allocation please? And also use some more meaningful units for the different sizes. Instead of this:

      [Note] InnoDB: Initializing buffer pool, total size = 17179869184, chunk size = 134217728                         
      [Note] InnoDB: Completed initialization of buffer pool

      I would like to see:

      [Note] InnoDB: Initializing buffer pool, total size = 16384MB, chunk size = 128MB
      		 
      [Note] InnoDB: Allocating buffer pool with page size = 2048KB
      		 
      [Note] InnoDB: Completed initialization of buffer pool

      Buffer pool size and chunk size could use MB and fall back to KB in case they are very small. Page size can be given in KB.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25652 Add support for SI suffixes in SET statement for configuring size-related variables

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27314 Buffer pool resize output: 14 minor typo/capitalization/uniformity/wording updates

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31628 InnoDB reports the wrong system tablespace size on bootstrap

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35498 InnoDB logger class causes significant code bloat

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 128093 ] MariaDB v4 [ 131608 ]
            danblack Daniel Black made changes -
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.7 [ 24805 ]
            danblack Daniel Black made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            danblack Daniel Black made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            danblack Daniel Black made changes -
            Assignee Daniel Black [ danblack ]
            Roel Roel Van de Paar made changes -
            Assignee Roel Van de Paar [ roel ]
            Roel Roel Van de Paar made changes -
            Assignee Roel Van de Paar [ roel ] Daniel Black [ danblack ]
            Roel Roel Van de Paar made changes -
            Roel Roel Van de Paar made changes -
            Summary humanize the bytes in innodb info/error messages Humanize the number of bytes in InnoDB buffer pool messages
            marko Marko Mäkelä made changes -
            Summary Humanize the number of bytes in InnoDB buffer pool messages Humanize the number of bytes in InnoDB messages
            marko Marko Mäkelä made changes -
            Fix Version/s 10.8.1 [ 26815 ]
            Fix Version/s 10.8 [ 26121 ]
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -

            People

              danblack Daniel Black
              danblack Daniel Black
              Votes:
              1 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.