Note, that it might help to have a little background as to why I want the
particular features I asked for.
Specifically, I run a server that normally has been 100-250 threads active at
any particular time. When the database starts getting slow, I need a way of
quickly determining what processes are loading up the server. Currently my
technique is to do something like
echo 'show full processlist' | mysql -u xyz -ptuv | grep -v Locked | grep -v Sleep
and start from there and start narrowing things out.
A related feature that would be invaluable, would be for Locked processes to
indicate which thread was holding the lock. That way if some query is locking
out a bunch of others, it should be easy to find.
Jorge del Conde wrote:
> Thank you for your suggestions. I will put the below in the TODO list.
> For technical support contracts, visit https://order.mysql.com/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde <jorge@stripped>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
> /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
> <___/ www.mysql.com
>>From: Mike Wexler [mailto:mwexler@stripped]
>>Sent: Tuesday, January 29, 2002 11:06 PM
>>Subject: feature request
>>I'd like to see the ability to filter out/in various types of
>>threads from the
>>process list. For example, I'd like to look at only threads
>>with a Command of
>>"Query" or only ones that aren't locked or asleep.
>>Also, the info section doesn't work well with multi-line SQL queries.
>>Also it would be very nice if this screen showed some totals.
>>total running threads, total locked threads.
>>It would be nice if you could double click on info and have a
>>window pop-up with
>>the entire query.
>>Before posting please check:
>>request this thread, email mycc-thread3@stripped
>>To unsubscribe, send a message to the address shown in the
>>List-Unsubscribe header of this message. If you cannot see
>>it, email mycc-unsubscribe@stripped instead.