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

Make innodb_max_dirty_pages_pct my.cnf variable a double

    XMLWordPrintable

Details

    Description

      Made innodb_max_dirty_pages_pct my.cnf variable a double

      Summary:
      Feature: Buffer Pool Control Enhancements

      This change is to fix: http://bugs.mysql.com/62534

      This makes innodb_max_dirty_pages_pct a double with min,default,max values
      0.001, 75, 99.999.

      This also makes innodb_max_dirty_pages_pct_lwm and adaptive_flushing_lwm
      doubles, as these sysvars are inter-dependent.

      Added more to the BUFFER POOL AND MEMORY section of SHOW INNODB STATUS:
      Percent pages dirty: X.X
      This is all n_dirty_pages / used_pages
      Percent all pages dirty: X.X
      This is all n_dirty_pages / all-pages
      Max dirty pages percent: X.X
      This is innodb_max_dirty_pages_pct

      Also changed all of buf from 2 to 3 digits of precision (%.2f -> %.3f).

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.