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" <[EMAIL PROTECTED]> To: "'Mojtaba Faridzad '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]