Hi, What would happen to my_table (~70MB of indexes) and its indexes if someone kills a an optimize table query - 'OPTIMIZE TABLE my_table' . Im wondering if i should provide a cancel button in my application during the optimization period. It is generally more user friendly to provide one, unless cancelling means having to repair the table or some similiar problem.
Thank you and regards Gamin.
