[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    optimize table - OK to abort?
From:       Dennis T Cook <DennisCook () comcast ! net>
Date:       2004-05-31 23:09:54
Message-ID: MPG.1b25854e9d7380d3989681 () news ! gmane ! org
[Download RAW message or body]

I've been running OPTIMIZE TABLE on a MyISAM table with an index on two
varchar type columns. The process status shows as "Repair with 
keycache". The table has 73 million rows. OPTIMIZE TABLE has
been running for several days with constant disk activity but low cpu 
usage and no way to estimate whether it's any where close to finishing. 
If I abort the mysql process doing the optimization, will the table or 
the index be damaged? The system is a development system and is really 
sluggish while the optimize is going on.
-- 
Dennis T.Cook


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]