Hello All-- We have a particularly large MyISAM table on an older MySQL (3.23.56) on an older Linux (RedHat 6.2). The table is always growing (data is never removed, except when we move it and start a new one). Yesterday one of the indexes started acting weird, so I took a look, and the .MYI file was 2.0G. I suspect it hit the 2G file size limit on Linux. We moved the broken table out of the way and started a new one with exactly the same spec.
It's now in a "crashed" state... I've been running myisamchk with some optimization options, but the table has almost 7.88M rows. After nearly 24 hours, it's currently working on 3.4M rows, in the first of 5 indexes. Is there a simple way I can drop the indexes and get access to the table? We need to move the last 3 months of data (insert ... select ?) to the new table we started, and then we can 'myisampack' this one and archive it... Or am I stuck waiting for myisamchk to finish? myisamchk --force --fast --update-state -O key_buffer=128M -O sort_buffer=128M -O read_buffer=4M -O write_buffer=4M <table> Any help appreciated... -Matt- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
