Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: alter table 不支持合并吗？
|
username: Johnpan
When using alter table to add or delete indexes, an error occurs when an alter contains multiple drops or adds, and it can only be split into multiple alters.
Version: tidb5.4.0
alter table vfs_directory drop index idx_root_id, drop index idx_parent_id, algorithm=instant
8200 - Unsupported multi schema change
To improve efficiency, please provide the following information. Clear problem descriptions can be resolved faster:
【TiDB Usage Environment】
【Overview】 Scenario + Problem Overview
【Background】 What operations have been done
【Phenomenon】 Business and database phenomena
【Problem】 The current problem encountered
【Business Impact】
【TiDB Version】
【Application Software and Version】
【Attachments】 Relevant logs and configuration information
- TiUP Cluster Display Information
- TiUP Cluster Edit config Information
Monitoring (https://metricstool.pingcap.com/)
- TiDB-Overview Grafana Monitoring
- TiDB Grafana Monitoring
- TiKV Grafana Monitoring
- PD Grafana Monitoring
- Corresponding module logs (including logs 1 hour before and after the problem)
If the question is related to performance optimization or fault troubleshooting, please download the script and run it. Please select all and copy and paste the terminal output results for upload.
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: