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]