Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
Before enabling PMEM in builds by default (cmake -DWITH_PMEM=ON), we want to make sure it doesn't have negative impact on performance on non-PMEM systems.
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
MDEV-33447 libpmem in RHEL 8+
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Axel Schwenke [ axel ] |
| Description | Before enabling PMEM in builds by default ({{cmake -DWITH_PMEM=ON}}), we want to make sure it doesn't have negative impact on performance on non-PMEM systems. |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Component/s | Storage Engine - InnoDB [ 10129 ] |
| Fix Version/s | 10.6 [ 24028 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Attachment | sysbench.pdf [ 56626 ] |
| Fix Version/s | 10.6.0 [ 24431 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.6.0 [ 24431 ] |
| Fix Version/s | N/A [ 14700 ] |
| Summary | benchmark performance for PMEM enabled builds | benchmark 10.6 performance for PMEM enabled builds |
| Workflow | MariaDB v3 [ 120054 ] | MariaDB v4 [ 134411 ] |
| Link |
This issue relates to |
The sysbench.pdf
matches what I observed when running performance tests after implementing a PMEM friendly redo log format and interface in MDEV-14425. With MDEV-14425, I observed some 10% to 15% improvement. I compared the speed of ib_logfile0 stored in the same PMEM device with and without mount -o dax.
| Link |
This issue relates to |
Benchmark has been run. Workload: all types of sysbench OLTP workloads, with and without explicit transaction boundaries. Datadir was located on /dev/shm and innodb_flush_log_at_trx_commit = 1 to make sure we test the effects of code changes and not IO limitations of the environment.