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.

Improve this question
3
  • Sounds like a job for expect or perl given the specific requirements. 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

Reset to default
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/

Improve this answer
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.

Improve this answer
0

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.