mysqladmin proc
mysqladmin kill ${Id} // The id that is causing the problem


-->-----Original Message-----
-->From: Bill Todd [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, September 10, 2003 11:51 AM
-->To: MySQL List (E-mail)
-->Subject: How identify long running query etc?
-->
-->Using MySQL and InnoDB, are there system tables or other tools that I
can
-->use to see which statements that are executing have consumed the most
CPU
-->time and find out which user, transaction and/or connection those
-->statements
-->belong to?
-->
-->If I identify a user that is causing a problem is there a way to
-->disconnect
-->that user?
-->
-->
-->--
-->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]

Reply via email to