Re: Slow Left Join on 100K row tables
Posted by: Biju Philips
Date: March 10, 2022 10:54AM

Thanks we have a slave replication on this server with the master at version 5 so not sure if we can change it to 8. But surely MySQL should be able to handle millions of rows in Left Join, no? I have only 100K in these two tables. Is there any other setting that is causing this?

Options: ReplyQuote


Subject
Written By
Posted
Re: Slow Left Join on 100K row tables
March 10, 2022 10:54AM


Sorry, only registered users may post in this forum.

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.