MySQL Forums
Forum List  »  Optimizer & Parser

Re: At Performance Limit for 2 GB RAM?
Posted by: Jay Pipes
Date: July 30, 2005 11:44AM

Nick,

There's really no need for the metadatatemp join, as far as I can tell. You can reduce the query to:

SELECT
dich_value
, COUNT(*) as count
FROM y_statsinfo as stats
WHERE stn_id = 2500
GROUP BY dich_value;

with no effect. For this query, having an index on (stn_id, dich_value) would be beneficial, but only if the number of rows returned by the stn_id = 2500 filter is less than around 35% of the total rows in the table. If not, it would be faster to do a simple table scan. Either case, if you're working with the majority of 20M rows in the index, a sequential scan is about the best you can do...

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: At Performance Limit for 2 GB RAM?
2522
July 30, 2005 11:44AM
3079
August 04, 2005 07:17PM


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.