more balance performance

Hi
My computer is AMD athlon 64 3400+ with 1.5G DDR. when i execute the
following sql in mysql 5.XX.
select c.filename, c.topic from articles c where c.topic in (select
a.topic from articles a group by a.topic having count(a.topic)>1) order
by topic;

It eat up all the cpu power , and the mysql server stop responsing
until end of this query. Even my apache stop responing too. How to fix
this? How can i set the CPU limit of each query connection?

thanks
from Peter (cmk128@hotmail.com)

Re: more balance performance

first, what are you trying to do?
second, you can put and explain in the beginning of the query and run it
to see what the server says about the query. in a query like this, i'd
definitely run an explain to find out where the bottlenecks are.



cmk128@hotmail.com wrote:
> Hi
> My computer is AMD athlon 64 3400+ with 1.5G DDR. when i execute the
> following sql in mysql 5.XX.
> select c.filename, c.topic from articles c where c.topic in (select
> a.topic from articles a group by a.topic having count(a.topic)>1) order
> by topic;
>
> It eat up all the cpu power , and the mysql server stop responsing
> until end of this query. Even my apache stop responing too. How to fix
> this? How can i set the CPU limit of each query connection?
>
> thanks
> from Peter (cmk128@hotmail.com)
>