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 |
---|---|
| Name of the milestone. |
| Timestamp when milestone was created. |
| Name of the database for which the milestone is created. |
| 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 | +----------------------------+----------------------------+---------------+-------------------+