Re: worst result in killing an optimize table query

2003-06-19 Thread Jeremy Zawodny
On Thu, Jun 19, 2003 at 02:24:52AM +0530, gamin wrote: > 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

worst result in killing an optimize table query

2003-06-18 Thread gamin
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,