MySQL Forums
Forum List  »  InnoDB

Table Stuck and MYSQL Hang when run table optimize table
Posted by: Gaurav Jain
Date: December 30, 2020 05:52AM

Hello

We have a table with almost 100000 records and have 36 fields in table

When i run OPTIMIZE TABLE MYTABLE then process just going on and after few seconds mysql also hang. Even in WHM when i try to restart mysql then it hang and we need to reboot the server

can anyone help me to solve the issue

Please note: This table work with lots of insert , select and delete queries

Options: ReplyQuote


Subject
Views
Written By
Posted
Table Stuck and MYSQL Hang when run table optimize table
185
December 30, 2020 05:52AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.