mysql-audit
AUDIT Plugin for MySQL. See wiki and readme for description. If you find the plugin useful, please star us on GitHub. We love stars and it's a great way to show your feedback. (by trellix-enterprise)
mysqld_exporter
Exporter for MySQL server metrics (by prometheus)
| mysql-audit | mysqld_exporter | |
|---|---|---|
| 2 | 12 | |
| 213 | 2,040 | |
| 3.3% | 2.1% | |
| 0.0 | 7.7 | |
| about 1 month ago | 3 days ago | |
| C | Go | |
| GNU General Public License v3.0 or later | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
mysql-audit
Posts with mentions or reviews of mysql-audit.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-03-09.
-
how to get tables used by mysql user
McAfee Enterprise Audit
-
Fetching date of the last time a DB was accessed.
There are other solutions -e.g. audit plugins, but writing to disk on every read can be very taxing. If modifications were enough, just monitoring the last update for files on the database dirs would be a quick and dirty way to do it.
mysqld_exporter
Posts with mentions or reviews of mysqld_exporter.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-11-28.
-
Monitoring MySQL with Prometheus and Grafana in Docker
To install it you can follow the instructions in the GitHub repository and you can run it in a Docker container as well.
-
Are there any tools that will suggest beneficial indexes to add? / Why doesn't MySQL/MariaDb have this functionality built in?
Prometheus and the mysqld_exporter can provide lots of good, detailed, real-time metrics on your performance.
-
Fetching date of the last time a DB was accessed.
What I would do is to persist those between restarts. If you need metrics, something like the prometheus-mysql-exporter (or any other scrapping process) can periodically query mysql for metrics, including (although not by default) performance_schema. That is what I would suggest to solve your monitoring (and would get you a robust and maintained metric system), plus counters will automatically solve the "reset to 0" on restart.
- Is it posible to get database based bandwidth consuming stats on a MySQL server?
-
Best Practices on Server Administration
As u/mtocker said, best practice today is to use a modern metrics-based monitoring platform like Prometheus and mysqld_exporter. This does much more than just "not offline".
-
Top key metrics for monitoring MySQL
To start monitoring MySQL with Prometheus, you’ll need to deploy the MySQL Exporter in your cluster. To deploy the exporter, you can use the example files provided below.
-
Anyone using official mysqld exporter?
I'm not MySQL user, but I'm writing a custom exporter for my NoSQL clusters, so studying the official mysql exporter (https://github.com/prometheus/mysqld_exporter) just for reference.
-
How do you manage exporters?
For example mysqld_exporter , you supply mysql connection details while mysqld_exporter itself running inside k8s as a just another container, then prometheus will scrape the mysqld-exporter. Deploying mysqld-exporter is just another Deployment.
-
Monitoring InnoDB Cluster members using Prometheus and MySQL Exporter
When manually rejoining the cluster fails, syncing the server's replication logs manually is an especially harrowing experience. These occurrences were greatly reduced by upgrading our cluster to the 8.0.x series of releases, making use of the Auto Rejoin feature, and monitoring our clusters members using MySQL Exporter
-
Unable to monitor MySQL server with TLS (mysqld_exporter).
"latest" as in 0.13.0-rc.0?
What are some alternatives?
When comparing mysql-audit and mysqld_exporter you can also consider the following projects:
mysqlconfigurer - Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.
mydumper - Official MyDumper Project
prometheus - The Prometheus monitoring system and time series database.