more balance performance

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
   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?

from Peter (

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. wrote:
Quoted text here. Click to load it

Site Timeline