Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Description
InnoDB is issuing writes to buffer pool pages and redo log, which are not actually modifying anything. Here are some examples:
- fsp_alloc_seg_inode_page() is unnecessarily zero-initializing FSEG_ID, which is already zero-initialized since MySQL 5.1.48 or MariaDB 5.1.49.
- btr_store_big_rec_extern_fields() is zero-initializing the most significant 32 bits of BTR_EXTERN_LEN, even though the field is zero-initialized in the BLOB pointer at least since MySQL 5.5.42, MariaDB 5.5.42.
- The function rtr_adjust_upper_level(), introduced in MySQL 5.7.5 and MariaDB 10.2.2, appears to be unnecessarily retrieving and null-modifying the preceding page (prev_page_no).
Attachments
Issue Links
- relates to
-
MDEV-12353 Efficient InnoDB redo log record format
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Link |
This issue relates to |
issue.field.resolutiondate | 2019-11-11 12:38:53.0 | 2019-11-11 12:38:53.929 |
Fix Version/s | 10.2.30 [ 24015 ] | |
Fix Version/s | 10.3.21 [ 24014 ] | |
Fix Version/s | 10.4.11 [ 24013 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 101018 ] | MariaDB v4 [ 156964 ] |