Hello,
reading the MySQL documentation I've run into the " show full
processlist\G" command. In my case I've got an output similar to this:
-----------------------------------------------------------------------------------------------------------------------------
mysql> show full processlist\G
*************************** 1. row ***************************
Id: 30127
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show full processlist
*************************** 2. row ***************************
Id: 30399
User: root
Host: localhost
db: this would be my DB
Command: Sleep
Time: 0
State:
Info: NULL
-----------------------------------------------------------------------------------------------------------------------------
What I'd like to know is how to get more info about the query
identified with 30399 (in this example). I mean, the exact query, like
"SELECT pr1, pr2 FROM someDB".
Thanks
Matias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
