I also want to know the answer to this question.If it's for me.I'll scan all the source code manually.But it's too complicated.
On Tue, Oct 7, 2008 at 1:02 AM, Olaf Stein < [EMAIL PROTECTED]> wrote: > It specifies the query in the Info field. > In your case the connection is "sleeping", nothing is being executed at the > moment, therefore info is NULL > > > > Olaf > > > On 10/6/08 11:38 AM, "MaBa.listas" <[EMAIL PROTECTED]> wrote: > > > 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 > > > ----------------------------------------- Confidentiality Notice: > The following mail message, including any attachments, is for the > sole use of the intended recipient(s) and may contain confidential > and privileged information. The recipient is responsible to > maintain the confidentiality of this information and to use the > information only for authorized purposes. If you are not the > intended recipient (or authorized to receive information for the > intended recipient), you are hereby notified that any review, use, > disclosure, distribution, copying, printing, or action taken in > reliance on the contents of this e-mail is strictly prohibited. If > you have received this communication in error, please notify us > immediately by reply e-mail and destroy all copies of the original > message. Thank you. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn