Inconsistent host format in SHOW PROCESSLIST?
Posted by: Pippo Pisellino
Date: August 08, 2014 02:58AM

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!

Options: ReplyQuote


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.