1

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.

3
  • Sounds like a job for expect or perl given the specific requirements.
    – Drav Sloan
    Commented Dec 14, 2015 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. Commented Dec 14, 2015 at 13:02
  • yeah, monit, plug-ins for Nagios not a bad idea. Failing that, a script around mysqld status Commented Dec 14, 2015 at 13:10

2 Answers 2

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/

0

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:

  1. Percona's PMM
  2. Shattered Silicon's fork of PMM called SSM

These are open source (free as in both speech and beer), 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.

Disclosure: I work at the database consultancy that maintains SSM.

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .