l: je...@gii.co.jp
> Web site: www.the-infoshop.com
>
>
> >-Original Message-
> >From: Claudio Nanni [mailto:claudio.na...@gmail.com]
> >Sent: Thursday, March 03, 2011 4:21 PM
> >To: sstap...@mnsi.net
> >Cc: mysql@lists.mysql.com
> >Subject: Re: Get MySQ
dio.na...@gmail.com]
>Sent: Thursday, March 03, 2011 4:21 PM
>To: sstap...@mnsi.net
>Cc: mysql@lists.mysql.com
>Subject: Re: Get MySQL server IP address in SQL
>
>Hi Steve,
>
>Thanks for your tip.
>
>It's not a cluster,
>I am building a tool to monitor mysql
Hi Steve,
Thanks for your tip.
It's not a cluster,
I am building a tool to monitor mysql performances and this information(*IP*)
is required in a stored procedure on the mysql-agents installations.
Being it possible to have multiple mysql instances on the same server the
only unique identifier wo
On Thu, 2011-03-03 at 13:43 -0600, Chris W wrote:
>
> On 3/2/2011 5:59 PM, Reindl Harald wrote:
> > Am 03.03.2011 00:31, schrieb Claudio Nanni:
> >> Anyone knows how to get the server* IP address* thru SQL?
> > no, because it is nonsense and has nothing to do with a db-server
> >
> > if you connec
On 3/2/2011 5:59 PM, Reindl Harald wrote:
Am 03.03.2011 00:31, schrieb Claudio Nanni:
Anyone knows how to get the server* IP address* thru SQL?
no, because it is nonsense and has nothing to do with a db-server
if you connect via tcp you know the ip
Isn't that kind of like going to someone
Am 03.03.2011 00:31, schrieb Claudio Nanni:
> Anyone knows how to get the server* IP address* thru SQL?
no, because it is nonsense and has nothing to do with a db-server
if you connect via tcp you know the ip
and even if not - what should give you mysqld
if the host has more than one ip?
sig
Anyone knows how to get the server* IP address* thru SQL?
--
Claudio
*mysql> select * from GLOBAL_variables where variable_name like 'hostname';*
*+---++*
*| VARIABLE_NAME | VARIABLE_VALUE |*
*+---++*
*| HOSTNAME | haarlemeer |*
*
