Javascript must be enabled to download our products and perform other essential functions on the website.

ionicons-v5-m
ionicons-v5-j
Buy Now Download Free Trial
ionicons-v5-m
ionicons-v5-f

How to Monitor MySQL

MySQL can be monitored via SNMP with the free Mysql-snmp module by Brice Figureau. There are many counters available under:

.1.3.6.1.4.1.20267.200.1
iso.org.dod.internet.private.enterprises.(??).mySQL.myStatus

But did you notice that (??) node in the counter path? That's because of how the MySQL MIB file is defined. Depending on what application you use for SNMP monitoring (it should be PA Server Monitor!!) it may have problems getting from the enterprises node to the mySQL node. This might be considered a MYSQL-SERVER.mib error.

This can be easily fixed with a small change to the MYSQL-SERVER.mib file.

Change this line:

::= { enterprises 20267 200 }
to this:
::= { enterprises mySQLRoot(20267) 200 }

Now that unnamed node has a name (mySQLRoot) most SNMP applications will be able to parse and traverse the MIB without problems.

Make sure the changed MIB file is in:

C:\Program Files\PA Server Monitor\MIBs

and restart the monitoring service so the changed MIB file is reparsed.

PA Server Monitor

Help Map