Hi,
I have a innodb table with around 60000000 of rows, when i execute optimize table, i obtain the next error:
±----------------------±---------±---------±------------ -------------------------------------------+
| Table | Op | Msg_type | Msg_text |
±----------------------±---------±---------±------------ -------------------------------------------+
| table | optimize | error | Lock wait timeout exceeded; try restarting transaction |
| table | optimize | status | Operation failed |
±----------------------±---------±---------±------------ -------------------------------------------+
2 rows in set, 1 warning (23 min 56.01 sec)
While the optimize was executing some other transactions try to insert in the table and they became locked because table was in use.
is there any variable to tuning to avoid this problem?
Thanks for your help.