MySQL Forums
Forum List  »  Performance

Re: Query causing CPU Spike to 100% after MYSQL upgrade
Posted by: Peter Brawley
Date: December 11, 2017 09:21PM

I don't see anything in the 5.7.19-5.7.20 change list that would make such a difference.

The query cross joins cct with cfit, ie it will return every logically possible combination of cct and cfit rows. Is that intentional?

Explicit join syntax (a join b on a.x=b.y) is much easier to read, debug, maintain.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Query causing CPU Spike to 100% after MYSQL upgrade
623
December 11, 2017 09:21PM


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.