SHOW ALTER MATERIALIZED VIEW

SHOW ALTER MATERIALIZED VIEW shows the building status of synchronous materialized views.

tip

This operation does not require privileges.

Syntax

SHOW ALTER MATERIALIZED VIEW [ { FROM | IN } db_name]

Parameters in brackets [] is optional.

Parameters

Parameter	Required	Description
db_name	no	The name of the database to which the materialized view resides. If this parameter is not specified, the current database is used by default.

Returns

Return	Description
JobId	The ID of refresh job.
TableName	The name of the table.
CreateTime	The time when refresh job is created.
FinishedTime	The time when refresh job is finished.
BaseIndexName	The name of the base table.
RollupIndexName	The name of the materialized view.
RollupId	The ID of the materialized view rollup.
TransactionId	The ID of transaction that waits to be executed.
State	The state of the job.
Msg	Error message.
Progress	Progress of the refresh job.
Timeout	Timeout for the refresh job.

Examples

Example 1: building status of synchronous materialized views

MySQL > SHOW ALTER MATERIALIZED VIEW\G
*************************** 1. row ***************************
          JobId: 475991
      TableName: lineorder
     CreateTime: 2022-08-24 19:46:53
   FinishedTime: 2022-08-24 19:47:15
  BaseIndexName: lineorder
RollupIndexName: lo_mv_sync_1
       RollupId: 475992
  TransactionId: 33067
          State: FINISHED
            Msg: 
       Progress: NULL
        Timeout: 86400
*************************** 2. row ***************************
          JobId: 477337
      TableName: lineorder
     CreateTime: 2022-08-24 19:47:25
   FinishedTime: 2022-08-24 19:47:45
  BaseIndexName: lineorder
RollupIndexName: lo_mv_sync_2
       RollupId: 477338
  TransactionId: 33068
          State: FINISHED
            Msg: 
       Progress: NULL
        Timeout: 86400
2 rows in set (0.00 sec)