Must force to use indexes, otherwise cluster is slow
Hello to all.
I don’t know how to formulate subject, but here is our situation. We’ve got one big table with 2.5mln records. We also run a query which joins 5-6 tables. Initial query was hanging the whole box – mysqld process was trying to take all memory and all swap of the server. Join is through primary keys.
We started to investigate and found out that “SHOW TABLE STATUS” always returns 100.
And with that query… The only way we managed to run it faster was to force it to use indexes. This really looks like cluster sometimes fails to select correct index to use. Is it worth to open a bug? May be someone could provide more detailed info on this?
Thanks,
Anton.
Subject
Views
Written By
Posted
Must force to use indexes, otherwise cluster is slow
2233
August 17, 2005 07:04PM
1460
August 18, 2005 11:14AM
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.