Re: MYSQL update taking to long need help
Let's see the actual Show Create Table results for each table.
Plus the result (inside BBCode code tags for human readability) of running
EXPLAIN
update schema1.phase3 as a
right join schema1.cqt as b on b.trayid = a.linking
set a.trayid = b.trayact, a.pallet = b.pallet ;
Plus why that's a right join instead of an inner join. Are you aware that your update will set a.trayid and a.pallet Null for rows in a with no matching rows in b? If so, then why not, for performance, handle those separately?
Plus MySQL version and how much RAM is available in this installation.
Plus, if the tables are InnoDB, innodb_buffer_pool_size, and if they're not then why not.
Subject
Written By
Posted
Re: MYSQL update taking to long need help
January 30, 2017 11:46AM
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.