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
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
On Wed, Sep 10, 2003 at 11:50:43AM -0700, Bill Todd wrote:
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?