Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.3, 10.2.0, 10.3.0
-
10.3.6-1
Description
The CREATE TABLE attribute page_compressed that was introduced in MariaDB 10.1.3 has no effect when innodb_doublewrite=0. This is because the actual compression only takes place within the doublewrite buffer code path.
The purpose of the doublewrite buffer is to guarantee crash-safety in the event that InnoDB is killed in the middle of a page write. Because it could become a performance bottleneck for write-heavy workloads, some users may choose to set innodb_doublewrite=0 and take the risk that crash recovery may fail. (The page should be referred to by the redo log, and a log checkpoint should not be made while a page write is still in progress, so the page corruption should be detected at InnoDB startup.)
Attachments
Issue Links
- relates to
-
MDEV-15529 IMPORT TABLESPACE unnecessarily uses the doublewrite buffer
-
- Closed
-
-
MDEV-25734 mbstream breaks page compression on XFS
-
- Closed
-
-
MDEV-11696 Page Compression Has No Effect on Table Data File Size
-
- Closed
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
1h 49m | 1 |
|
941d 20h 18m | 1 |
|
146d 3h 39m | 1 |
|
3d 18h 15m | 1 |
|
3h 54m | 1 |
|
23d 17h 32m | 2 |
|
1d 6h 39m | 1 |