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

Performance of XtraDB slows down significantly on long benchmarks

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: 10.0.9
        • Fix Version/s: 10.0.10
        • Component/s: None
        • Labels:
          None

          Description

          I have run 6h tests using both Percona Server 5.6.16-64 as MariaDB 10.0.9 using XtraDB 5.6.15-63.0. Benchmark used is Linkbench using 10x database, i.e. maxid = 100000001 and database is ~100G. Buffer pool used is 50G. I will attach results from LinkBench measure phase where the performance decrease is evident. Using ROW_FORMAT=compressed this decracation if severe and using uncompressed tables not so significant but clear. I have run compressed also using MariaDB 10.0.9 using Oracle InnoDB and there I can't see similar performance decrease.

          Percona Server 5.6.16-64 and ROW_FORMAT=COMPRESSED using linkbench with 10x database and 6h time limit. Similar run with MariaDB 10.0.10 (unofficial). End results:

          Percona: 1998 ops/sec
          MariaDB: 21074 ops/sec

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Performance of XtraDB slows down significantly on long benchmarks

                  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 - - edited

                  Suggested fix from Alexey Stroganov (Percona)

                  === modified file 'storage/innobase/buf/buf0flu.cc'
--- storage/innobase/buf/buf0flu.cc	2014-02-17 11:12:40 +0000
+++ storage/innobase/buf/buf0flu.cc	2014-03-25 15:09:52 +0000
@@ -1655,7 +1655,7 @@
 		n->flushed = 0;
 	}
 
-	n->evicted += count;
+	n->flushed += count;
 }
 
 /*******************************************************************//**
                  Show
                  jplindst Jan Lindström added a comment - - edited Suggested fix from Alexey Stroganov (Percona) === modified file 'storage/innobase/buf/buf0flu.cc' --- storage/innobase/buf/buf0flu.cc 2014-02-17 11:12:40 +0000 +++ storage/innobase/buf/buf0flu.cc 2014-03-25 15:09:52 +0000 @@ -1655,7 +1655,7 @@ n->flushed = 0; } - n->evicted += count; + n->flushed += count; } /*******************************************************************//**

                    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:
                        Resolved: