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

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

                Dates

                Created:
                Updated:
                Resolved: