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 you're just not seeing
them in SHOW PROCESSLIST - if they took much time, you wouldn't be
getting that 500-per-second number.
Its purpose is more to show you what is going on with queries that don't
run so quickly, or when your database experiences a deadlock.
If you do really need to get a list of all queries that ran in a
particular second, you might be able to work some magic with MySQL's
"general log" aka the "query log". You have to specifically enable
that, and it is a record of ALL queries including data inserts and
updates, so it can become a large file quickly - beware.
Dan
Peter Van Dijck wrote:
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 this work? How can I get a full list of queries running
within, say, a particular second?
Thanks!
Peter
--
Dan Buettner
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
