MYSQL Stats - are there any working ones out there?

[allxrt]

Hi, I've done a search and the only 3 I can find are currently broken or no longer available, does anyone have a working solution to obtain MYSQL stats from a Ubuntu server running MYSQL?

Thanks in advance

[TheWitness]

I've got one. Been meaning to clean it up and get it released, I never seem to find time to though.

[allxrt]

No problem, I totally understand I'll temporarly use a docker version of percona to monitor in the meantime.

[TheWitness]

Hey, since this is all volunteer stuff, if I give you the package, can you do the cleanup and once done release the modified device template?

[allxrt]

I can certianly try, can you give me a hint on the type of things that are involved in a clean up?

[TheWitness]

Basically, I merged the work of two authors. Many of the Graphs were duplicated. So, you review all the graphs, and pick the one you want to keep. Note the template id, then delete the entry in the Host Template, and then delete both the Graph Template and Data Template associated with the Graph that will not be kept.

When you get to the bottom of the pile, just Export the Device Template again an upload it.

[TheWitness]

With the most recent versions of MariaDB, you can not grant a read only super privilege to users on remote hosts, which is great as some of the status commands did not work if you were trying to monitor multiple MariaDB servers. The information schema is reporting much of what is needed these days too.

[allxrt]

Could you point me to the file and I will have a go, many thanks.

[TheWitness]

Use the Package Import pick to import this one.

[gossamer]

So there currently isn't a standard way to monitor as common of a service as mariadb/MySQL with cacti? This capabiity isn't included with the default installation or otherwise readily available?

Is there a template database available where we can find templates for common services like postfix/dovecot etc?

[TheWitness]

If you just want to track processes, the HMIB and THOLD plugins works fine. The WEBSEER plugin also helps with service checks. Monitoring comes in many flavors. It depends on what you are interested in.

[gossamer]

If you just want to track processes, the HMIB and THOLD plugins works fine. The WEBSEER plugin also helps with service checks. Monitoring comes in many flavors. It depends on what you are interested in.

Thanks so much for your help.

Just the basics to start - iostat, CPU utilization, bandwidth utilization/errors/etc, checks for common services like dovecot, postfix, apache, mariadb, etc.

None of this is available by default and I must install some third-party plugin? Where can I find them? Is there some type of cacti repository where people manage these?

[TheWitness]

Just use the Net-SNMP Device Template plus HMIB for those metrics.

[TheWitness]

Here is an example of what you can track with HMIB. Note my MariaDB servers take a lot of memory.