MySQL Forums
Forum List  »  Performance

Re: Is this model correct?
Posted by: Rick James
Date: March 11, 2010 09:04AM

Currently:
SELECT  cu_name,ck_kt_no
    FROM  cu_customer, ck_customerkeys
    WHERE  cu_no = ck_cu_no
      AND  cu_subsid = ck_cu_subsid
      AND  ck_key = 'examplecode';

Please do
SHOW CREATE TABLE cu_customer;
SHOW CREATE TABLE ck_customerkeys;
And use aliases in the SELECT. -- I can't tell which field is in which table.
That would tell me to which table does ck_key belongs.

And you may as well show us the 4-table query.

Also SHOW TABLE STATUS -- want to see table sizes.

(Sorry, I prefer output of the above statements over trying to express the equivalent in English -- too much change of an important item sloughed over in the translation to English.)

innodb_buffer_pool_size should be set to about 70% of _available_ RAM when you get to your 16GB machine.

Options: ReplyQuote


Subject
Views
Written By
Posted
3031
March 10, 2010 04:00AM
Re: Is this model correct?
1340
March 11, 2010 09:04AM
1475
March 12, 2010 04:17AM
1422
March 12, 2010 10:02AM


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.