SHOW ALTER

description

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

Syntax:

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

Note:

TABLE COLUMN: Show ALTER tasks to modify columns
Supports Syntax [WHERE TableName|CreateTime|FinishTime|State] [ORDER BY] [LIMIT]
TABLE ROLLUP: Shows tasks for creating or deleting ROLLUP indexes
If db_is not specified Name, using the current default DB
CLUSTER: Shows tasks related to cluster operations (only used by administrators! To be implemented...)

example

  1. Task execution showing all modified columns of default db

    SHOW ALTER TABLE COLUMN;
  2. Shows task execution for a table that last modified columns

    SHOW ALTER TABLE COLUMN WHERE TableName = "table1" ORDER BY CreateTime DESC LIMIT 
  3. Shows task execution for creating or deleting ROLLUP index for specified db

    SHOW ALTER TABLE ROLLUP FROM example_db;
  4. Show cluster operations related tasks (Administrators only! To be implemented...)

    SHOW ALTER CLUSTER;

keyword

SHOW,ALTER