MySQL Forums
Forum List  »  Performance

Not using index properly in 4.1.7
Posted by: F de Bruijn
Date: December 07, 2004 03:22AM

Hello,

I've recently upgraded from version 4.0.16 to 4.1.7 because I needed subqueries. But when I installed it and got it to work for my application I noticed that the indexes that where on my tables where no longer used. Also when I dropped them and recreated all of the indexes (primary and secondary) it still didn't use the index. Is there some change in how MySQL uses the indexes on tables ?
In 4.0.16 I got a result within a second from a table with 16 million records. In version 4.1.7 this was a minute.

I've run the explain on the select and saw that in 4.1.7 the select did not use the index that it was using in 4.0.16. To check if there was an problem with the table I have run the ANALYZE TABLE, but that says everything was OK.

Does anyone has the same problem in 4.1.7 or does someone know how to solve it please let me know.

With kind regards,

F. de Bruijn

Options: ReplyQuote


Subject
Views
Written By
Posted
Not using index properly in 4.1.7
3274
December 07, 2004 03:22AM
1834
December 07, 2004 08:41AM
1916
December 07, 2004 09:47AM
1995
December 08, 2004 11:31AM
1951
December 08, 2004 01:51PM
1799
December 09, 2004 09:50AM


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.