Thanks Victor! when a process is running, I cannot stop it. before finding
the optimized query, I may run some queries which stop server to give the
service to the other users.
usually I find slow query when I have LEFT JOIN on a big table. I try not to
use left join by temporary tables or by programming.
----- Original Message -----
From: "Victor Pendleton" <VPendleton@stripped>
To: "'Mojtaba Faridzad '" <mfaridzad@stripped>;
<mysql@stripped>
Sent: Tuesday, July 27, 2004 8:34 AM
Subject: RE: how to set timeout process
> You can not limit connections per minute but you can limit connections per
> hour for a user. Can the process not be stopped during your testing phase?
> Can the queries not be optimized?
>
> -----Original Message-----
> From: Mojtaba Faridzad
> To: mysql@stripped
> Sent: 7/27/04 6:52 AM
> Subject: how to set timeout process
>
> Hi,
>
> How can I set a timeout in MySQL (mysqld-nt) not to run a query more
> than X
> minutes? some of queries (when I am testing), make the CPU 100% busy for
> a
> long time and I cannot kill the process, even when I go to winmysqladmin
> and
> under "process" I kill the process but MySQL doesn't care.
>
> thanks,
> Mojtaba
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
