MV_MILESTONES

This view displays the list of milestones that have been created in the engine. This is the list of points that can be used to perform PITR.

_first_milestone , this milestone name is created automatically when a database is created. The other milestone names are created by explicitly using CREATE MILESTONE. If a name is not specified in the CREATE MILESTONE command, the milestone time will be used as the default milestone name.

MV_MILESTONES will not show milestones older than the retention period for unlimited storage databases.

Column name

Description

MILESTONE_NAME

Name of the milestone.

MILESTONE_TIME

Timestamp when milestone was created.

DATABASE_NAME

Name of the database for which the milestone is created.

DATABASE_LOCATION

The remote storage location of the database for which the milestone is created.

Example::

SELECT * FROM information_schema.MV_MILESTONES;
+----------------------------+----------------------------+---------------+-------------------+
| MILESTONE_NAME             | MILESTONE_TIME             | DATABASE_NAME | DATABASE_LOCATION |
+----------------------------+----------------------------+---------------+-------------------+
| _first_milestone           | 2021-11-10 11:44:25.956998 | x_db          | s3bucket          |
| 2021-11-10 11:44:27.911987 | 2021-11-10 11:44:27.911987 | x_db          | s3bucket          |
| x_db_milestone             | 2021-11-10 11:44:35.175052 | x_db          | s3bucket          |
+----------------------------+----------------------------+---------------+-------------------+

Last modified: June 7, 2023

Was this article helpful?