MySQL Forums
Forum List  »  Performance

Re: slow update-join query
Posted by: Peter Brawley
Date: June 07, 2022 01:19PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
511
June 07, 2022 12:55PM
216
June 07, 2022 01:00PM
Re: slow update-join query
239
June 07, 2022 01:19PM
255
June 07, 2022 02:27PM
233
June 07, 2022 02:55PM
235
June 07, 2022 03:26PM
227
June 07, 2022 05:06PM
212
June 07, 2022 06:20PM
247
June 08, 2022 09:51AM


Sorry, you can't reply to this topic. It has been closed.

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.