MySQL Forums
Forum List  »  MyISAM

Re: Performance by Selections
Posted by: Peter Brawley
Date: February 28, 2019 05:10PM

> I am not sure how to get the Create Table results.

Eh? In the mysql client program execute ...

show create table pos_ord_headers\G
show create table pos_ord_lines\G

... copy the results, paste them in a post here.

> I am not certain if the second query induces swapping

Do you know how to find out? What is your OS?

4GB RAM might be insufficient for a query on 120 million rows. Is the machine dedicated to MySQL, or does other software run on it? If the latter, how much RAM is available for MySQL?'

> I am not certain what the key_buffer_size is by default.

That's not the question (though if it had been, it's dead simple to look up in the manual). The question is what is the setting, which you find by executing ...

select @@key_buffer_size;

Edited 1 time(s). Last edit at 02/28/2019 08:29PM by Peter Brawley.

Options: ReplyQuote

Written By
February 19, 2019 09:35AM
February 19, 2019 12:02PM
February 21, 2019 06:58AM
February 21, 2019 01:13PM
February 28, 2019 03:56PM
Re: Performance by Selections
February 28, 2019 05:10PM
March 04, 2019 10:14AM
March 04, 2019 11:08AM
March 22, 2019 06:09AM
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.