|
Posted by lark on October 31, 2006, 9:28 am
Please log in for more thread options
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)
>
| 
XML Sitemap