Edit

SHOW ALTER MATERIALIZED VIEW

Description

Shows the refresh tasks of the single-table sync refresh materialized views.

Syntax

SHOW ALTER MATERIALIZED VIEW [FROM db_name];

Parameters in brackets [] is optional.

Parameters

ParameterRequiredDescription
db_namenoThe name of the database to which the materialized view resides. If this parameter is not specified, the current database is used by default.

Returns

ReturnDescription
JobIdThe ID of refresh job.
TableNameThe name of the table.
CreateTimeThe time when refresh job is created.
FinishedTimeThe time when refresh job is finished.
BaseIndexNameThe name of the base table.
RollupIndexNameThe name of the materialized view.
RollupIdThe ID of the materialized view rollup.
TransactionIdThe ID of transaction that waits to be executed.
StateThe state of the job.
MsgError message.
ProgressProgress of the refresh job.
TimeoutTimeout for the refresh job.

Examples

Example 1: Show the refresh tasks of the sync refresh 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)