MySQL Forums
Forum List  »  MyISAM

Re: Performance by Selections
Posted by: Greg Mundt
Date: February 28, 2019 03:56PM

I am not sure how to get the Create Table results. These tables have been in place for 10 years.

Query Cache is not enabled

I could switch to inner join, it would not be an issue

4 GB RAM

I am not certain if the second query induces swapping

I am not certain what the key_buffer_size is by default.

Options: ReplyQuote


Subject
Views
Written By
Posted
1239
February 19, 2019 09:35AM
841
February 19, 2019 12:02PM
791
February 21, 2019 06:58AM
691
February 21, 2019 01:13PM
Re: Performance by Selections
754
February 28, 2019 03:56PM
722
February 28, 2019 05:10PM
733
March 04, 2019 10:14AM
714
March 04, 2019 11:08AM
746
March 22, 2019 06:09AM
670
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.