ADMIN-REPAIR-TABLE
ADMIN-REPAIR-TABLE
Name
ADMIN REPAIR TABLE
Description
statement used to attempt to preferentially repair the specified table or partition
grammar:
ADMIN REPAIR TABLE table_name[ PARTITION (p1,...)]
illustrate:
- This statement only means to let the system try to repair the shard copy of the specified table or partition with high priority, and does not guarantee that the repair can be successful. Users can view the repair status through the SHOW REPLICA STATUS command.
- The default timeout is 14400 seconds (4 hours). A timeout means that the system will no longer repair shard copies of the specified table or partition with high priority. Need to re-use this command to set
Example
Attempt to repair the specified table
ADMIN REPAIR TABLE tbl1;
Try to repair the specified partition
ADMIN REPAIR TABLE tbl1 PARTITION (p1, p2);
Keywords
ADMIN, REPAIR, TABLE