log-slow-queries option...

[danb]

I've been dealing with a number of mysqld processes recently which don't seem to end and eat up 50M of memory at a time. None of our programmers are admitting to (or realizing) causing a potentially site stopping problem.
I've enabled the log-slow-queries option but I am wondering if this will even work correctly as it states:

"A statement is logged to the slow query log after it has been executed and after all locks have been released. Log order may be different from execution order." -- http://dev.mysql.com/doc/mysql/en/Slow_query_log.html

So what of queries which end up running continuously and while not growing or decreasing in memory or CPU usage, never end. Are they logged if the queries run too long but never end?

If they aren't, is there another way to track down this problem without reviewing all of the possibly detrimental code produced in the last week? I've got logging setup on both our development and live servers so hopefully someone will reproduce the problem sooner or later.


Thanks
Dan Brown