mysql monitoring tool

Question

Is there any monitoring tool for mysql which will send a notification mail to mentioned email ID ? It must monitor below parameters. 1. mysql more than 500 concurrent connections. 2. mysql deadlocks. 3. connection between mysql and application.

And some more like this.

Sounds like a job for `expect` or `perl` given the specific requirements. — Drav Sloan, Dec 14 '15 at 10:58
It's unlikely, but you could look at the plugins for Nagios (or its forks) and see if one of those might be a starting point. — roaima, Dec 14 '15 at 13:02
yeah, monit, plug-ins for Nagios not a bad idea. Failing that, a script around mysqld status — Rui F Ribeiro, Dec 14 '15 at 13:10

snoopy · Answer 1 · 2015-12-17T18:04:05.910

1

MySQL monitoring tools provided by mysql

Or use any of the command line tools listed below and customize it to your requirements as the tools are built using perl scripts use snmp traps in scripts to notify a mail server to trigger a mail to receive email notification

http://www.tecmint.com/mysql-performance-monitoring/

edited Dec 17 '15 at 18:04

answered Dec 17 '15 at 16:55

snoopy

33
2
8

Gordan Bobić · Answer 2 · 2023-07-31T22:45:29.207

1

While there are probably many more, there are two tools I can think of off the top of my head that will do all of what you listed out of the box:

These are docker deployed prometheus+grafana stacks with very database-optimised dashboards and alerting works via Grafana functionality. Email is one of many alerting channels it can use to send out alerts.

edited Jul 31 '23 at 22:45

answered Jul 31 '23 at 20:42

Gordan Bobić

381
1
6

mysql monitoring tool

2 Answers2