MySQL Forums
Forum List  »  Optimizer & Parser

Re: performing mysqldump corrected query issue?
Posted by: Peter Sylvester
Date: June 26, 2012 02:08PM

I have the resolution. The problem was that mysql was using the wrong table at the root table for the query. I'm not sure why it would have caused such a massive time issue, but I used a STRAIGHT_JOIN on the smaller joining table and now it seems to be working fine. I guess when I did the mysqldump it may have affected the analysis of the index cardinality and corrected the issue on the server.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: performing mysqldump corrected query issue?
1212
June 26, 2012 02:08PM


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.