MySQL 4.0.12 max on AIX 4.3.2 HA. When I use show full processlist on localhost, all
Hosts show as localhost. but when I use show full processlist from remote, all Hosts
show as remote IP.
as follow:
mysql> show full processlist;
+-----+-----------------+-----------------+------------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info
|
+-----+-----------------+-----------------+------------+---------+------+-------+-----------------------+
| 14 | gege | localhost:3425 | NewProduct | Sleep | 744 | | NULL
|
| 20 | yuheyang | localhost:3277 | NewProduct | Sleep | 4044 | | NULL
|
| 21 | yuheyang | localhost:3278 | NewProduct | Sleep | 4044 | | NULL
|
| 22 | yuheyang | localhost:3279 | NewProduct | Sleep | 4132 | | NULL
|
| 23 | yuheyang | localhost:3280 | NewProduct | Sleep | 4137 | | NULL
|
| 24 | yuheyang | localhost:3312 | NewProduct | Sleep | 1946 | | NULL
|
| 25 | yuheyang | localhost:3313 | NewProduct | Sleep | 1946 | | NULL
|
| 26 | yuheyang | localhost:3314 | NewProduct | Sleep | 1946 | | NULL
|
| 27 | yuheyang | localhost:3315 | NewProduct | Sleep | 1946 | | NULL
|
| 28 | root | localhost | NULL | Query | 0 | NULL | show
full processlist |
| 29 | happynessrabbit | localhost:44555 | NewProduct | Sleep | 291 | | NULL
|
| 30 | happynessrabbit | localhost:44556 | NewProduct | Sleep | 291 | | NULL
|
| 31 | happynessrabbit | localhost:44557 | NewProduct | Sleep | 291 | | NULL
|
| 32 | happynessrabbit | localhost:44558 | NewProduct | Sleep | 291 | | NULL
|
| 115 | happynessrabbit | localhost:44654 | NewProduct | Sleep | 1809 | | NULL
|
| 116 | happynessrabbit | localhost:44655 | NewProduct | Sleep | 1801 | | NULL
|
| 117 | happynessrabbit | localhost:44657 | NewProduct | Sleep | 1792 | | NULL
|
| 118 | happynessrabbit | localhost:44658 | NewProduct | Sleep | 1781 | | NULL
|
| 119 | happynessrabbit | localhost:44659 | NewProduct | Sleep | 1776 | | NULL
|
| 131 | happynessrabbit | localhost:44671 | NewProduct | Sleep | 1715 | | NULL
|
| 137 | happynessrabbit | localhost:44677 | NewProduct | Sleep | 1711 | | NULL
|
| 156 | happynessrabbit | localhost:44696 | NewProduct | Sleep | 1603 | | NULL
|
| 162 | happynessrabbit | localhost:44704 | NewProduct | Sleep | 1561 | | NULL
|
| 172 | gege | localhost:44721 | NULL | Sleep | 17 | | NULL
|
+-----+-----------------+-----------------+------------+---------+------+-------+-----------------------+
24 rows in set (0.00 sec)
on remote:
mysql> show full processlist;
+-----+-----------------+---------------------+------------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State |
Info |
+-----+-----------------+---------------------+------------+---------+------+-------+-----------------------+
| 14 | gege | 192.168.5.108:3425 | NewProduct | Sleep | 727 | |
NULL |
| 20 | yuheyang | 192.168.5.108:3277 | NewProduct | Sleep | 4027 | |
NULL |
| 21 | yuheyang | 192.168.5.108:3278 | NewProduct | Sleep | 4027 | |
NULL |
| 22 | yuheyang | 192.168.5.108:3279 | NewProduct | Sleep | 4115 | |
NULL |
| 23 | yuheyang | 192.168.5.108:3280 | NewProduct | Sleep | 4120 | |
NULL |
| 24 | yuheyang | 192.168.5.108:3312 | NewProduct | Sleep | 1929 | |
NULL |
| 25 | yuheyang | 192.168.5.108:3313 | NewProduct | Sleep | 1929 | |
NULL |
| 26 | yuheyang | 192.168.5.108:3314 | NewProduct | Sleep | 1929 | |
NULL |
| 27 | yuheyang | 192.168.5.108:3315 | NewProduct | Sleep | 1929 | |
NULL |
| 28 | root | 192.168.5.108 | NULL | Sleep | 668 | |
NULL |
| 29 | happynessrabbit | 192.168.5.108:44555 | NewProduct | Sleep | 274 | |
NULL |
| 30 | happynessrabbit | 192.168.5.108:44556 | NewProduct | Sleep | 274 | |
NULL |
| 31 | happynessrabbit | 192.168.5.108:44557 | NewProduct | Sleep | 274 | |
NULL |
| 32 | happynessrabbit | 192.168.5.108:44558 | NewProduct | Sleep | 274 | |
NULL |
| 115 | happynessrabbit | 192.168.5.108:44654 | NewProduct | Sleep | 1792 | |
NULL |
| 116 | happynessrabbit | 192.168.5.108:44655 | NewProduct | Sleep | 1784 | |
NULL |
| 117 | happynessrabbit | 192.168.5.108:44657 | NewProduct | Sleep | 1775 | |
NULL |
| 118 | happynessrabbit | 192.168.5.108:44658 | NewProduct | Sleep | 1764 | |
NULL |
| 119 | happynessrabbit | 192.168.5.108:44659 | NewProduct | Sleep | 1759 | |
NULL |
| 131 | happynessrabbit | 192.168.5.108:44671 | NewProduct | Sleep | 1698 | |
NULL |
| 137 | happynessrabbit | 192.168.5.108:44677 | NewProduct | Sleep | 1694 | |
NULL |
| 156 | happynessrabbit | 192.168.5.108:44696 | NewProduct | Sleep | 1586 | |
NULL |
| 162 | happynessrabbit | 192.168.5.108:44704 | NewProduct | Sleep | 1544 | |
NULL |
| 172 | gege | 192.168.5.108:44721 | NULL | Query | 0 | NULL |
show full processlist |
+-----+-----------------+---------------------+------------+---------+------+-------+-----------------------+
24 rows in set (0.00 sec)
