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?

I'll often use mytop to do that.  But I'm sorta biased on that
topic. :-)

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 3 days, processed 122,829,045 queries (449/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to