Does the OPTIMIZE TABLE Operation Lock Tables on an RDS DB Instance?
When the OPTIMIZE TABLE operation is performed on an RDS DB instance, the tables are locked only for a short period of time. During the table locking period, DML operations can be performed but other DDL operations cannot be executed concurrently. Additionally, this operation rebuilds the table, taking a relatively long time and consuming significant CPU and disk resources. If there is a high volume of concurrent DML operations, the final table locking duration will be extended. To minimize the impact on workloads, perform the OPTIMIZE TABLE operation during off-peak hours.
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot