You are here

MPM Questions & Answers

Taxonomy upgrade extras: 

Question: What is the MySQL Performance Monitor (MPM) monitoring and what data is the agent sending?

Answer: The MPM agent is gathering mainly the output of:

SHOW GLOBAL STATUS;
SHOW GLOBAL VARIABLES;
SHOW ENGINE INNODB STATUS;

and some data of the INFORMATION_SCHEMA and the PERFORMANCE_SCHEMA


Question: What MPM modules do you provide at the moment?

Answer: You can find a list of the provided modules here.

I have gotten the FromDual modules and templates working on 2 of our 3 database servers. The last one, I keep getting the below errors in the FromDual log file:

3387:2013-02-05 12:55:51.296 - INFO: FromDual Performance Monitor for MySQL (0.9) run started.
3387:2013-02-05 12:55:51.297 - INFO: FromDualMySQLagent::setAgentLock
3387:2013-02-05 12:55:51.298 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
3387:2013-02-05 12:55:51.299 - WARN: Another agent with PID 3366 (our PID is 3387) is running. We will abort now.

Are there any suggestions on how to fix this?

Thank you!

aderrcomment

Hello, i installed FromDual on a MySQL 5.6 and made it work fine sending data. But now every 5 minutes i get the message of the Zabbix_agent unreachable in that server. Agent is working fine and network too. I get this error on Zabbix log: 2916:20140618:125301.324 Zabbix agent item "FromDual.MySQL.check" on host "HOST" failed: first network error, wait for 5 seconds 2931:20140618:125309.359 Zabbix agent item "FromDual.MySQL.check" on host "HOST" failed: another network error, wait for 5 seconds 2931:20140618:125314.491 resuming Zabbix agent checks on host "HOST": connection restored Anyone can help me solving this? Thank you
bformosocomment