show full processlist question

2006-06-27 Thread Peter Van Dijck
Hi, I want to get a full list of all queries being run at a specific moment... If I look at mytop output, I'm hitting 500 queries per second. If I do show full processlist though, I only see 1 query as output - it's 'show full processlist' itself! And a few sleeping queries sometimes. How does

Re: show full processlist question

2006-06-27 Thread Dan Buettner
Peter, SHOW PROCESSLIST is a moment-in-time snapshot of connections and their activities. It shows you what all is going on at the instant you issue the command; it does not show you recent commands (even those that happened a second ago). Many of your queries are very likely so fast that

show full processlist question

2005-01-28 Thread Ângelo M. Rigo
Hi I didn´t find it in the documentation I would like to know if the collumn time in the command show full processlist show the seconds the query is taking to execute!? Thank´s in advance - Yahoo! Acesso Grátis - Internet rápida e grátis.