hello there,
I want to find out processes that are causing other
processes in MySQL to backlog.
when i use show processlist command. It gives me the
snapshot of all the processes currently running. if i fired a
long-running query it gets "locked" and due to this other small
queries which i fired after words also get locked.
Now how will i get the processes that is causing other
processes to be locked.
i am using windows 2000 and MySQL 4.0
is there any solution?
Thanks & Regards
Kapil.
------------------------ Yahoo! Groups Sponsor --------------------~-->
Check out the new improvements in Yahoo! Groups email.
http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/HKFolB/TM
--------------------------------------------------------------------~->
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/