How identify long running query etc?

2003-09-10 Thread Bill Todd
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

RE: How identify long running query etc?

2003-09-10 Thread Dathan Vance Pattishall
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

Re: How identify long running query etc?

2003-09-10 Thread Jeremy Zawodny
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?