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]