Inconsistent host format in SHOW PROCESSLIST?
We have a MySQL DB server (5.6.16), to whom several application servers connect.
One of the application servers is showing in a different format. Instead of <ip>:<port>, it shows in <hostname>:<port>. Example:
+---------+---------+--------------+------------+---------+---------+--------+------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+---------+--------------+------------+---------+---------+--------+------+
| 7705019 | someapp | 9.9.9.1:4515 | someapp_db | Sleep | 1476317 | | NULL |
| 8443240 | someapp | strange:5706 | someapp_db | Sleep | 1388 | | NULL |
| 8443319 | someapp | 9.9.9.0:4575 | someapp_db | Sleep | 1 | | NULL |
| 8443445 | someapp | 9.9.9.2:5120 | someapp_db | Sleep | 104 | | NULL |
+---------+---------+--------------+------------+---------+---------+--------+------+
The /etc/hosts configuration is uniform for all the servers.
When I try to emulate the same behavior using a combinaton of netcat (on the db server) and telnet (from the app servers), I don't see anything inconsistent under netstat.
How does MySQL gather the hostname in the "Host" field?
We suspect some misconfiguration in the network, so any information would be useful. Thanks!
Subject
Written By
Posted
Inconsistent host format in SHOW PROCESSLIST?
August 08, 2014 02:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.