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]