more balance performance

Hi
My computer is AMD althon 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)

cmk128@hotmail.com wrote:
> Hi
> My computer is AMD althon 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)
>

You can't set the CPU limit for each connection.

The key here is the size of your tables, indexes, buffer sizes, etc.
There's a lot you can do to optimize, but without knowing the details of
your database it's impossible for us to help you.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================