[MDEV-5949] Performance of XtraDB slows down significantly on long benchmarks Created: 2014-03-25  Updated: 2014-03-26  Resolved: 2014-03-26

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.9
Fix Version/s: 10.0.10

Type: Bug Priority: Critical
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
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

 Comments   
Comment by Jan Lindström (Inactive) [ 2014-03-25 ]

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

Comment by Jan Lindström (Inactive) [ 2014-03-25 ]

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;
 
 }
 
 
 /*******************************************************************//**

Generated at Thu Feb 08 07:08:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.