MySQL Forums
Forum List  »  MyISAM

Re: SELECT query running for 9h (till now)
Posted by: Rick James
Date: August 07, 2013 07:54PM

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
and surround them with [ code ] and [ / code ]

How many rows are you expecting to get?

Note that it estimates 720K from the "ref" table.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SELECT query running for 9h (till now)
1382
August 07, 2013 07:54PM


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.