Re: Joins performed without indexes
Originally Posted by
DigitalShadow
My dedicated server is being slow, and we are investigating the root cause of the issue.
What tables don't use indexes?
I'm also seeing this on our server and have requested the top 10 unique queries as suggested by DrByte.
100,000 per day average: You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
15M per day average: your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
Rick
RixStix (dot) com
aka: ChainWeavers (dot) com
Bookmarks