root@db02:/var/log/mysql# mysql -e "show full processlist\G" -p
Enter password:
*************************** 1. row ***************************
      Id: 1
    User: system user
    Host:
      db: NULL
 Command: Connect
    Time: 542
   State: Waiting for master to send event
    Info: NULL
Progress: 0.000
*************************** 2. row ***************************
      Id: 2
    User: system user
    Host:
      db: NULL
 Command: Connect
    Time: 4596
   State: Reading event from the relay log
    Info: NULL
Progress: 0.000
*************************** 3. row ***************************
      Id: 209
    User: datanalytics
    Host: da01.prod.bpm.cdc.ot01.net:60386
      db: mercury
 Command: Sleep
    Time: 230
   State:
    Info: NULL
Progress: 0.000
*************************** 4. row ***************************
      Id: 210
    User: datanalytics
    Host: da01.prod.bpm.cdc.ot01.net:60387
      db: mercury
 Command: Sleep
    Time: 230
   State:
    Info: NULL
Progress: 0.000
*************************** 5. row ***************************
      Id: 323
    User: datanalytics
    Host: da03.prod.bpm.cdc.ot01.net:41830
      db: mercury
 Command: Sleep
    Time: 40
   State:
    Info: NULL
Progress: 0.000
*************************** 6. row ***************************
      Id: 345
    User: datanalytics
    Host: da03.prod.bpm.cdc.ot01.net:41856
      db: mercury
 Command: Sleep
    Time: 1
   State:
    Info: NULL
Progress: 0.000
*************************** 7. row ***************************
      Id: 346
    User: root
    Host: localhost
      db: NULL
 Command: Query
    Time: 0
   State: NULL
    Info: show full processlist
Progress: 0.000
root@db02:/var/log/mysql#