Safe to KILL a mysql process REPLACEing records in a large myisam table?

Posted by threecheeseopera on Stack Overflow See other posts from Stack Overflow or by threecheeseopera
Published on 2010-05-03T03:52:13Z Indexed on 2010/05/03 3:58 UTC
Read the original article Hit count: 275

Filed under:

I have a REPLACE query running for a few days now on a few MyISAM tables, the largest having 20+million records. I need it to stop.

It is, basically:

REPLACE INTO really_large_table (a,b,c,d) 
SELECT e,f,g,h FROM 
big_table INNER JOIN huge_table ON
big_table.x LIKE CONCAT('%', huge_table.y, '%');

I need to KILL it, and I am worried that I may corrupt really_large_table.

Because the sub-query itself takes a significant amount of time, the REPLACEing probably occurs (relatively) infrequently; if this is true, does this make it less likely for the data to become corrupted?

For the curious, here is the SO question asked about the query I am trying to kill.

© Stack Overflow or respective owner

Related posts about mysql