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 optimization period. It is generally
>    more user friendly to provide one, unless cancelling means having
>    to repair the table or some similiar problem.

MySQL will discard the tempporary files and leave your data
unchanged.  At least that's what I've seen happen.
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.13: up 16 days, processed 531,850,131 queries (375/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to