Hi, There is no way to kill slow queries autmatically unless you were to write a script (maybe in perl or php?) to do this job. I have a similar problem and am thinking of replicating the database just to avoid this problem. I would then direct certain type of queries to the replicated server. The issue I have is I need selects not to lock the table for update! On FreeBSD this seems also to cause the CPU usage to jump very high.
I was thinking of writing some test scripts, but I think the real answer for both of us may be to change to the InnoDB table type. Have you tried this? use ALTER TABLE type=innodb, after you have intalled mysql-max and created the tablespace. I hope this helps, Ken ----- Original Message ----- From: "°í¼ø¹Î" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 03, 2002 5:28 AM Subject: How can I kill the slow query automatically? > My DB has many update queries and a few select queries. > Sometimes select queries take very long time so update can't > proceed. I can kill the select query manually. But I can't check > the status all the time. > > Are there any ways to kill slow query automatically? If you know, > please let me know. Any information will be appreciated. > > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
