MPM Installation

I want to monitor a specific mysql database.

This is the output of “show databases” command:

+----------+
| Database |
+----------+
| ...      |
| ...      |
| ...      |
| A        |
| zabbix   |
+----------+

Let’s say I want to monitor database A.

The problem is that I monitor also zabbix databases (mysql and zabbix are on the same machine).

So for example if I see the chart “MySQL Queries executed” I obtain also the query executed by zabbix on zabbix database.

How can I …

Hi,

In the process of setting up the agent I was modifying the FromDualMySQLagent.conf and setting up the databases as in the documentation:

[your_first_db_name]

Type         = mysqld
Modules      = process mysql myisam innodb

The database name should of course be consistant with a hostname on the Zabbix server. I have gotten all this to work correctly.

I am wondering however, is there the ability to change the database name in the config file to a label and then as an option point it at a database name? …

Hello

I have successfully installed and configured zabbix to work with your performance monitoring. However, every once in a while, the graphs in zabbix do not display any information. It seems when I invoke FromDualMySQLagent.pl things go back to normal. Do I need to setup a cron to refresh the data?

I have included the following line in /etc/zabbix/zabbix_agentd/userparameter_mysql.conf:

UserParameter=FromDual.MySQL.check,/usr/local/mysql_performance_monitor/FromDualMySQLagent.pl …