From: Mike Wexler
Date: January 30 2002 7:57pm
Subject: Re: feature request
List-Archive: http://lists.mysql.com/gui-tools/9
Message-Id: <3C585037.9020105@tias.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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:

> Hi,
> 
> Thank you for your suggestions.  I will put the below in the TODO list.
> 
> 
> Regards,
> Jorge
> --
> 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
> 
> 
> 
> 
>>-----Original Message-----
>>From: Mike Wexler [mailto:mwexler@stripped] 
>>Sent: Tuesday, January 29, 2002 11:06 PM
>>To: mycc@stripped
>>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 threads, 
>>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: 
>>http://www.mysql.com/products/mycc/index.html
>>posting. To 
>>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.
>>
>>