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
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 connect via tcp
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
...@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 performances and this information(*IP*)
is required
-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 MySQL server IP address in SQL
Hi Steve,
Thanks for your tip.
It's not a cluster,
I am
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 |*
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?