The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago):
Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. I guess whenever the hostname lookup fails you just see the IP address. HTH/h On 3/18/03 2:36 PM, "Andrew Braithwaite" <[EMAIL PROTECTED]> wrote: > 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 > --------------------------------------------------------------------- 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