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

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 and