MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Table Stuck and MYSQL Hang when run table optimize table
1470
Gaurav Jain
December 30, 2020 05:52AM
Re: Table Stuck and MYSQL Hang when run table optimize table
646
Peter Brawley
December 30, 2020 09:48AM
Re: Table Stuck and MYSQL Hang when run table optimize table
748
Gaurav Jain
December 30, 2020 09:54PM
Re: Table Stuck and MYSQL Hang when run table optimize table
527
Peter Brawley
December 31, 2020 11:40AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.