Anyone else notice this, or is it just me? Andrew
-----Original Message----- From: Andrew Braithwaite Sent: Tuesday 18 March 2003 23:05 To: 'R. Hannes Niedner'; MySQL Mailinglist Subject: RE: mysqladmin processlist = weird in version 4.0.12 Hi, I do understand what you're saying and I did read the 4.0.12 changelog and appreciate the addition of the TCP port in that display, but all the hostnames in the processlist are displaying as the localhost of the mysql server that they are connecting to instead of the hostnames of the server that is connecting. The "/etc/hosts" file is fine and is the same as it was before.... Bug or feature? Cheers, Andrew -----Original Message----- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED] Sent: Tuesday 18 March 2003 22:48 To: Andrew Braithwaite; MySQL Mailinglist Subject: Re: mysqladmin processlist = weird in version 4.0.12 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 --------------------------------------------------------------------- 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
