MySQL Forums
Forum List  »  Performance

Re: Time performance in query Inner Join
Posted by: Rick James
Date: July 10, 2011 12:19PM

We are 13 messages into this thread, and I still don't have all the information needed to analyze your problem. The EXPLAIN does not match the one SELECT you have shown.

Please provide ALL of these in a SINGLE message for this thread:
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Time performance in query Inner Join
851
July 10, 2011 12:19PM


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.