Re: Get MySQL server IP address in SQL

2011-03-03 Thread Chris W
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

Re: Get MySQL server IP address in SQL

2011-03-03 Thread Steve Staples
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

Re: Get MySQL server IP address in SQL

2011-03-03 Thread Claudio Nanni
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

RE: Get MySQL server IP address in SQL

2011-03-03 Thread Jerry Schwartz
...@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

Re: Get MySQL server IP address in SQL

2011-03-03 Thread Claudio Nanni
-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

Get MySQL server IP address in SQL

2011-03-02 Thread Claudio Nanni
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 |*

Re: Get MySQL server IP address in SQL

2011-03-02 Thread Reindl Harald
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?