[MDEV-10798] Implement ALL user statements for handling xtradb changed page bitmaps (xdb files) Created: 2016-09-12  Updated: 2017-10-27  Resolved: 2017-02-28

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

Type: Task Priority: Major
Reporter: Joffrey MICHAIE Assignee: Unassigned
Resolution: Won't Fix Votes: 2
Labels: None

Issue Links:
Relates
relates to MDEV-7472 Implementation of user statements for... Closed
relates to MDEV-13833 implement --innodb-track-changed-pages Open

 Description   

Hello,

First of all thanks Jan for implementing the first batch of commands manipulating XDB files on https://jira.mariadb.org/browse/MDEV-7472

I would like to follow up on the last comments, and open this new request to implement the remaining user commands:

  • RESET CHANGED_PAGE_BITMAPS
  • PURGE CHANGED_PAGE_BITMAPS BEFORE <lsn>

Documentation: https://www.percona.com/doc/percona-server/5.6/management/changed_page_tracking.html#changed-page-tracking-statements

I am especially interested in the last one, as when we enable innodb_track_changed_pages feature, it can fill up disk space quickly on busy servers. It's a good practice to purge the xdb files up to LSN from last successful backup.

Thanks in advance,
Joffrey

 Comments   
Comment by Sergei Golubchik [ 2017-02-28 ]

There is no good way of adding this syntax, certainly not in 10.1.
And in 10.2 XtraDB doesn't work at the moment at all.

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