SHOW-ALTER

SHOW-ALTER

Name

SHOW ALTER

Description

This statement is used to display the execution of various modification tasks currently in progress

SHOW ALTER [CLUSTER | TABLE [COLUMN | ROLLUP] [FROM db_name]];

TABLE COLUMN: show ALTER tasks that modify columns Support syntax [WHERE TableName|CreateTime|FinishTime|State][ORDER BY] [LIMIT] TABLE ROLLUP: Shows the task of creating or deleting a ROLLUP index If db_name is not specified, the current default db is used CLUSTER: Displays tasks related to cluster operations (only for administrators! To be implemented...)

Example

1. Display the task execution of all modified columns of the default db

    SHOW ALTER TABLE COLUMN;

2. Display the task execution status of the last modified column of a table

   SHOW ALTER TABLE COLUMN WHERE TableName = "table1" ORDER BY CreateTime DESC LIMIT 1;

3. Display the task execution of creating or deleting ROLLUP index for the specified db

   SHOW ALTER TABLE ROLLUP FROM example_db;

4. Show tasks related to cluster operations (only for administrators! To be implemented...)

   SHOW ALTER CLUSTER;

Keywords

SHOW, ALTER

Best Practice