[MDEV-26860] MariaDB 10.5 does not do idle checkpoint (regression) Created: 2021-10-19 Updated: 2022-11-11 Resolved: 2021-11-22 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server, Storage Engine - InnoDB |
| Affects Version/s: | 10.5.12 |
| Fix Version/s: | 10.5.13, 10.6.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | carlos tutte | Assignee: | Marko Mäkelä |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | need_feedback, performance | ||
| Attachments: |
|
||||||||||||||||
| Issue Links: |
|
||||||||||||||||
| Description |
|
MariaDB 10.5 does not checkpoint as I would expect (i.e same as in MariaDB 10.4 or PS 5.7 ) . Attached is the graph of how MariaDB 10.5 checkpoints, i.e it let's redo log get to max checkpoint age, then checkpoints everything , then start over. SEIS On MariaDB : SEIS on PS 5.7: It can be seen that "Last checkpoint at xxxx" is close to LSN on PS, but on MariaDB 10.5 it will remain with a fixed value until max checkpoint age. In the attachment it can be seen that every ~4 hours the redo logs gets full, does an almost complete checkpoint and starts again. This causes an stall of a few seconds while the disks (which luckily are fast) do the checkpoint On MariaDB 10.4 this does not happen and I have also compared configuration between 10.4 and 10.5 and could not find anything. This other bug report |
| Comments |
| Comment by Marko Mäkelä [ 2021-10-19 ] |
|
Thank you for the report. This feels like a duplicate of |