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.

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