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:

Hi Fabio,

There are several ways to do this. The most simple one but possibly not what you need is:

mysql> pager grep A
SHOW DATABASES;

The better way to do this IMHO is:

mysql> SHOW DATABASES LIKE 'A';

And the best way (works in MySQL 5.0 and newer) IMHO is:

mysql> SELECT * FROM information_schema.schemata WHERE schema_name = 'A';

I hope this helps you solving your problem?

Regards,
Oli

oli

Wed, 2013-06-26 19:59

Languages