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

Inadequate background LRU flushing for write workloads with InnoDB compression

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.9
        • Fix Version/s: 10.0
        • Component/s: None
        • Labels:
          None

          Description

          The provided fix candidate for https://mariadb.atlassian.net/browse/MDEV-5949 significantly improved the situation but not fixed it fully. Now the performance remains quite a stable for whole 6h LinkBench run. However, still performance numbers measured using MariaDB 10.0.9 containing the fix candidate contain a significant difference between XtraDB and InnoDB.

          XtraDB: Requests/second = 15700
          InnoDB: Requests/second = 20485

          These number without using multi-threaded flush or atomic writes and doublewrite on. I will attach full outputs from both LinkBench measure phases and used configuration file and used load and run commands for LinkBench.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                jplindst Jan Lindström added a comment -

                https://bugs.launchpad.net/percona-server/+bug/1295268

                Show
                jplindst Jan Lindström added a comment - https://bugs.launchpad.net/percona-server/+bug/1295268
                Hide
                Permalink
                jplindst Jan Lindström added a comment -

                Measure phase results.

                Show
                jplindst Jan Lindström added a comment - Measure phase results.
                Hide
                Permalink
                jplindst Jan Lindström added a comment -

                https://bugs.launchpad.net/percona-server/+bug/1298812

                This seen only on long running benchmarks using fast IO, decreasing the importance.

                Show
                jplindst Jan Lindström added a comment - https://bugs.launchpad.net/percona-server/+bug/1298812 This seen only on long running benchmarks using fast IO, decreasing the importance.

                  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: