[MDEV-5960] Inadequate background LRU flushing for write workloads with InnoDB compression Created: 2014-03-27  Updated: 2023-01-22  Resolved: 2023-01-22

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - XtraDB
Affects Version/s: 10.0.9
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None

Attachments: File newstats.tgz    

 Description   

The provided fix candidate for 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.

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

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

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

Measure phase results.

Comment by Jan Lindström (Inactive) [ 2014-04-24 ]

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

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

Comment by Elena Stepanova [ 2023-01-22 ]

XtraDB is no longer provided.

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