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
Subject
Views
Written By
Posted
2711
October 03, 2013 12:15AM
Re: Query running from past two days.
1451
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.