Re: slow update-join query
MySQL version? Amt of RAM available to MySQL? Does the machine swap during the query?
Let's see the results of ...
show create table table1;
show create table table2;
explain analyze update table1 a, table2 t set a.col1 = 1 where a.col2 = t.col2 and a.col3 = t.col3;
If version < 8, remove analyze from the explain cmd.
Subject
Views
Written By
Posted
230
June 07, 2022 12:55PM
Re: slow update-join query
98
June 07, 2022 01:19PM
108
June 07, 2022 02:27PM
102
June 07, 2022 02:55PM
108
June 07, 2022 05:06PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.