Re: MYSQL update taking to long need help

[Peter Brawley]

innodb_buffer_pool_size should be 65-75% of RAM available to MySQL.

The right join persuades MySQL it might as well read the whole cqt table, but a foreign key links phase3.linking to cqt.trayid, so there can be no phase3.linking value unmatched by a cqt.trayid value. So a right join from cqt to phase3 (equivalent to a left join from phase3 to cqt) on those two columns is incoherent. Lose "right" in the update command so MySQL can use the cqt trayid index.