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: 345
        
mysql
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