Hello,
I use the script from Percona:
https://github.com/percona/percona-monitoring-plugins/blob/master/cacti/scripts/ss_get_mysql_stats.php
In snmp.conf you need to add a line like this:
extend mysql /usr/local/sbin/snmp/mysql
...where /usr/local/sbin/snmp/mysql just starts ss_get_mysql_stats.php
using php.
Then your SNMP monitoring software needs to understand the data. I use
LibreNMS with a corresponding app plugin.
Best regards,
Peter
On 04/11/2024 06:20, Daniel Black via discuss wrote:
Well there is this blog
https://www.fromdual.com/monitoring-your-mariadb-database-with-snmp
Though use --batch and --skip-column-names on mariadb client rather
than needing grep/cut/sed things:
VALUE=$(mariadb --user=root --batch --skip-column-names -e 'SELECT
variable_value FROM information_schema.global_status WHERE
variable_name LIKE "threads_running"')
On Mon, 4 Nov 2024 at 03:36, Noah via discuss <[email protected]> wrote:
Ahoy List Members,
I hope you are well. Is there a good guide that explains how to set up
monitoring mariaDB via SNMP?
Cheers,
Noah
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
