I just wanted to know if the MySQL 5.5 with InnoDB will lock the whole table instead of some specific rows for SELECT query while UPDATE query is running on that specific table?
I can see that the SELECT queries stop responding while I was running the below query. All of the associated services were down in that particular period.
UPDATE table SET column='sample' where column is null;
Around 3.6 million(Total: 4 Million) rows were going to updated with this query.
- Index on the column which is part of where clause makes any effect on this?
- Is there any possible way to minimise the execution time? I am ok with the query changes as long as the output remains the same.