MySQL Forums
Forum List  »  Performance

Re: subquery vs. join?
Posted by: Magnus Olsson
Date: January 20, 2005 06:52AM

When executing such a query I analyze the used amount of memory and the current CPU-usage in the windows task manager. The CPU-usage is only ca 10% and memory usage around 60% when executing the join, that indicates that the system doesn't suffer from insufficient system resources, doesn't it?.

When I examine the thread of the join query in MySQL Administrator it seems to do a lot of "copying to temporary table". Is there a variable that can be adjusted so it performs more operations in RAM memory?

Options: ReplyQuote


Subject
Views
Written By
Posted
20420
December 03, 2004 02:52AM
7126
December 05, 2004 03:03AM
5941
December 05, 2004 07:52PM
6149
January 20, 2005 03:48AM
Re: subquery vs. join?
5293
January 20, 2005 06:52AM
4662
January 21, 2005 11:43PM
4862
January 21, 2005 11:38PM
3880
January 20, 2005 04:41PM


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.