如何监视MySQL查询错误，超时和登录尝试? [英] How to monitor MySQL query errors, timeouts and logon attempts?

问题描述

在设置第三方封闭源CMS(Sitefinity)时，安装程​​序不会创建运行它所必需的所有表和过程.该软件本身缺少日志记录系统，这使我感到奇怪:我可以跟踪和监视MySQL中失败的SQL语句吗?

While setting up a third party closed source CMS (Sitefinity) the setup doesn't create all tables and procedures necessary to run it. The software lacks a logging system itself and it made me wonder: could I trace and monitor failing SQL statements from MySQL?

这不仅解决解决Sitefinity问题的目的.我通常会想知道发送到MySQL服务器的内容是什么，而不是想深入了解软件产品或设置调试环境等.

This serves more than only the purpose of solving my issue with Sitefinity. More often I wonder what's send to the MySQL server, not wanting to dive into the software products or setup a debugging environment etc.

我尝试了JetProfiler(仅用于性能)，并查看了其他几个，但是尽管它们监视很多，但它们不监视查询失败，超时或登录尝试.有谁知道可以向我显示此信息的商业，免费的探查器，跟踪器，监视工具?

I tried JetProfiler (only performance) and looked through a few others, but although they monitor a lot, they don't monitor query failures, timeouts or logon attempts. Does anyone know a profiler, tracer, monitoring tool, commercial or free, that can show me this information?

推荐答案

查看Kontrollbase-它监视MySQL服务器所需的几乎所有内容，包括连接失败，连接中止等.它具有50多种不同的图形，性能调整报告，高级使用情况分析报告，安全检查等等.它也是100％免费的. http://kontrollsoft.com/software-kontrollbase

Check out Kontrollbase - it monitors just about everything you could want for MySQL servers including failed connections, aborted connections, etc. It has over 50 different graphs, performance tuning reports, advanced usage analytics reporting, security checks, and much much more. It's also 100% FREE. http://kontrollsoft.com/software-kontrollbase

上面列出的同一页面上有一个在线演示.看看吧！

There's an online demo available on the same page link listed above. Check it out!

这篇关于如何监视MySQL查询错误，超时和登录尝试?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！