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: 291
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