update table with replace string1 string2 I need replace string1 to string2 in column big tabe.
My table weight 1.7GB. For update I will be use:
UPDATE table SET column = REPLACE( column, 'search', 'replace' ) ; 

So, I have several questions:


Will table lock during procedure? Should I hide public part my site or not?  
How long time this procedure can executing?
How better run this? Maybe 'screen'? if my ssh connection will closed. 


Mysql 5.5.53
See http://mysql.rjweb.org/doc.php/deletebig#deleting_in_chunks for a technique of chunking a table.  It is aimed at DELETE, but can easily be adapted to UPDATE.

This should avoid the timeouts and hangs.