MySQL Forums
Forum List  »  MyISAM

Re: Query running from past two days.
Posted by: Rick James
Date: October 05, 2013 09:38AM

SHOW CREATE TABLE is more descriptive than DESCRIBE; please use it so I can see your indexes.

> on u.val_1 = f.val_1

will need an index _starting_ with val_1 (on either table).

Without a suitable index, it must scan table2 12486272 times or scan table1 68934522 times.
That could easily take days.

> 41224 Slow queries

It sounds like you need help with other queries, too.

Some discussion of compound indexes, etc:
http://mysql.rjweb.org/doc.php/index1

Options: ReplyQuote


Subject
Views
Written By
Posted
2576
October 03, 2013 12:15AM
Re: Query running from past two days.
1390
October 05, 2013 09:38AM


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.