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

Default value of 16kb for innodb page size in sys views

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.11, 11.4, 11.8
    • 10.11
    • None
    • None

    Description

      The sys views
      -innodb_buffer_stats_by_schema
      -innodb_buffer_stats_by_table
      -x_innodb_buffer_stats_by_schema
      -x_innodb_buffer_stats_by_table

      uses default value of 16384, if the pages are not compressed. This can be problematic if the innodb page size is configured as something different from the default value. Dynamic fetching of actual page size could be a better way to have accurate value.

      format_bytes(SUM(IF(ibp.compressed_size = 0, 16384, compressed_size))) AS allocated,

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37083 Inconsistency between sys.innodb_buffer_stats_by_table and information_schema.innodb_buffer_page

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              mariadb-satishkumar Satish Kumar
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.