Re: Agent Proxy don't forward queries to the Analyser
Posted by: Jeff Keller
Date: May 05, 2010 06:32AM

I am having similar results. In the Query Analyzer, all that is listed are the following:

SHOW /*!50000 ENGINE */ INNODB STATUS
SHOW /*!50000 GLOBAL */ STATUS
SHOW /*!50000 GLOBAL */ VARIABLES
SHOW SLAVE STATUS

In my setup, my MySQL database listens on 3307 so I wouldn't have to change my clients to all use a different port other than 3306.

In /etc/mysql-monitor-agent.ini:

proxy-address=:3306
proxy-backend-addresses = 127.0.0.1:3307

In /etc/instances/mysql/agent-instance.ini:

[mysqld]
user = root
password = XXXXXX
hostname = 127.0.0.1
port = 3306

Any assistance would be appreciated.

Thanks,
Jeff

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Agent Proxy don't forward queries to the Analyser
3023
May 05, 2010 06:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.