Resuming MySQL indexing

Posted by gmemon on Stack Overflow See other posts from Stack Overflow or by gmemon
Published on 2010-04-29T22:10:49Z Indexed on 2010/04/29 22:17 UTC
Read the original article Hit count: 290

Filed under:
|
|

Hello All,

I have been building index on a 200 million row table for almost 14 hours. Due to resource over-consumption on the machine (because of a separate incident), the machine cashed. Clearly, I want to avoid another 14 hours to re-construct the index. Is there a way that I can resume the construction of index from the point (or slightly back) where the machine crashed? I can see the temporary files created.

Thanks

© Stack Overflow or respective owner

Related posts about mysql

Related posts about index