MySQL Forums
Forum List  »  Performance

Re: Bad order by performance (5.7.12 under Aurora)
Posted by: Frederic Descamps
Date: November 26, 2019 01:46PM

Ciao Nicola,

the temp table might not involve slowness, it depends if it goes to disk or not.

However it might be good to have also the tables definitions too.

I also recommend you to try MySQL 8 where you can benefit from many optimizer improvements.

We also have now explain format=tree and explain analyze !

Regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Bad order by performance (5.7.12 under Aurora)
437
November 26, 2019 01:46PM


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.