MySQL Forums
Forum List  »  Performance

Re: High CPU Utilization
Posted by: Craig Dominaux
Date: September 23, 2005 08:52AM

Thanks Jay

So this is what I have done created 2 Indexes and limited the group_uid and attribute_name to 50 (I know for a fact that these values will never go past 20 characters but I set it to 50 to be safe.

CREATE INDEX datatree_attribute_id_nam_idx ON horde_datatree_attributes (datatree_id, attribute_name(50) );
CREATE INDEX datatree_group_id_idx ON horde_datatree (group_uid(50), datatree_id);

I was able to modify the code and remove GROUP BY and ORDER BY from the query because it is only suppose to return 1 row at all times.

I will update you on the performance once I get a load

Options: ReplyQuote


Subject
Views
Written By
Posted
4528
September 21, 2005 03:23PM
1882
September 21, 2005 05:28PM
1970
September 22, 2005 09:48AM
1648
September 22, 2005 01:13PM
1773
September 22, 2005 01:50PM
2996
September 23, 2005 07:37AM
Re: High CPU Utilization
1627
September 23, 2005 08:52AM
1630
September 23, 2005 09:14AM
1671
September 23, 2005 02:45PM
1732
September 23, 2005 04:00PM
1686
September 23, 2005 11:27AM
1810
September 23, 2005 12:03PM
1660
September 23, 2005 12:43PM


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.