Re: Agent Proxy don't forward queries to the Analyser

[Jeff Keller]

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