MySQL Forums
Forum List  »  MyISAM

Re: Performance by Selections
Posted by: Peter Brawley
Date: February 21, 2019 01:13PM

Show Create Table results for the two tables please.

Is the query cache enabled? If so, had that first query been run recently, or at least since the last boot?

Left Join forces table scan and summing of nulls, why not inner join?

How much RAM?

Does the 2nd query induce swapping?

what is key_buffer_size?

Options: ReplyQuote


Subject
Views
Written By
Posted
1244
February 19, 2019 09:35AM
854
February 19, 2019 12:02PM
793
February 21, 2019 06:58AM
Re: Performance by Selections
694
February 21, 2019 01:13PM
759
February 28, 2019 03:56PM
725
February 28, 2019 05:10PM
735
March 04, 2019 10:14AM
716
March 04, 2019 11:08AM
750
March 22, 2019 06:09AM
674
March 22, 2019 09:29AM


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.