List:General Discussion« Previous MessageNext Message »
From:Victor Pendleton Date:July 27 2004 12:34pm
Subject:RE: how to set timeout process
View as plain text  
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
Thread
Errcode: 27J S23 Jul
Re: Errcode: 27Aman Raheja23 Jul
Re: Errcode: 27J S24 Jul
RE: Errcode: 27J S24 Jul
  • Fulltext boolean search resultsleegold25 Jul
    • Re: Fulltext boolean search resultsMichael Stassen25 Jul
      • Re: Fulltext boolean search resultsleegold25 Jul
        • Re: Fulltext boolean search resultsMichael Stassen25 Jul
RE: Errcode: 27J S26 Jul
  • how to deal with a string of categoriesMojtaba Faridzad26 Jul
    • Re: how to deal with a string of categoriesBrent Baisley26 Jul
    • Re: how to deal with a string of categoriesSGreen26 Jul
      • Re: how to deal with a string of categoriesMojtaba Faridzad26 Jul
        • Re: how to deal with a string of categoriesSGreen26 Jul
  • Re: how to deal with a string of categoriesMartijn Tonies26 Jul
  • how to set timeout processMojtaba Faridzad27 Jul
    • /etc/my.cnfWolfgang Riedel27 Jul
      • Re: /etc/my.cnfWolfgang Riedel27 Jul
RE: Errcode: 27J S26 Jul
RE: how to set timeout processVictor Pendleton27 Jul
  • Re: how to set timeout processMojtaba Faridzad27 Jul
  • A possible bugLeonardo Javier Belén27 Jul
RE: Errcode: 27J S27 Jul
Re: A possible bugLeonardo Javier Belén28 Jul