It says in the change log that it added the port to make it easier to see where the connection is coming from. 146.101.143.72:48753 gives you a lot more information than "host1"
>From the release announcement -- * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. -----Original Message----- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:36 PM To: [EMAIL PROTECTED] Subject: mysqladmin processlist = weird in version 4.0.12 Hi all, Anyone know why "mysqladmin processlist" is not showing the host that is connected, but instead is showing the following in v4.0.12: <<truncated excerpt>> +-----+---------+----------------------+----------+-------- | Id | User | Host | db | Command +-----+---------+----------------------+----------+-------- | 530 | fcgi | 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi | 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi | 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi | 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi | 146.101.143.72:40745 | multimap | Sleep It used to show: +-----+---------+-------+----------+-------- | Id | User | Host | db | Command +-----+---------+-------+----------+-------- | 530 | fcgi | host1 | multimap | Sleep | 536 | fcgi | host2 | multimap | Sleep | 545 | fcgi | host3 | multimap | Sleep | 556 | fcgi | host2 | multimap | Sleep | 570 | fcgi | host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
