Index usage in 4.1.7
Posted by: F de Bruijn
Date: December 10, 2004 10:03AM

Does someone know why indexes that where working in 4.0.16 suddenly are not working anymore in version 4.1.7.
Is there a change in how MySQL uses the index on a table ? My query performance is dramatic now. I've gone from 0.12 sec. to a 20 sec. wait time. Did any one else noticed this behaviour ? Forcing the index to be used by the query does not help. Does it has to do with the 'cardinality' of the columns when you run explain on a SELECT ?

If something did change in the new version 4.1.7 can someone tell me how the indexes are used by MySQL now ?

With kind regards,

F. de Bruijn

Options: ReplyQuote


Subject
Views
Written By
Posted
Index usage in 4.1.7
8616
December 10, 2004 10:03AM
4279
December 13, 2004 05:47PM
4310
December 14, 2004 02:41AM
3629
January 27, 2005 03:27PM
3779
February 15, 2005 03:48PM
3334
November 23, 2005 04:48PM
3869
March 22, 2005 08:44AM


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.