MV_ MILESTONES
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
This view displays the list of milestones that have been created in the engine.
_
, this milestone name is created automatically when a database is created.CREATE MILESTONE
.CREATE MILESTONE
command, the milestone time will be used as the default milestone name.
MV_
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 |
+----------------------------+----------------------------+---------------+-------------------+
Last modified: June 7, 2023