Do you have a question? Post it now! No Registration Necessary. Now with pictures!
October 31, 2006, 1:49 am
rate this thread
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
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 (firstname.lastname@example.org)
- » cannot start mysql on redhat through "service" command
- — Next thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum