You are here
Monitor a specific database
Wed, 2013-06-26 15:05 — Fabio
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 isolate the monitor for database A?
Taxonomy upgrade extras:
information_schema helps you to find databases
There are several ways to do this. The most simple one but possibly not what you need is:
The better way to do this IMHO is:
And the best way (works in MySQL 5.0 and newer) IMHO is:
I hope this helps you solving your problem?
Regards,
Oli