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          |
+----------------------------+----------------------------+---------------+-------------------+

MV_MILESTONES

Was this article helpful?

Was this article helpful?