blocks|key|294476|text|试试MySQL+Cacti模板。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|entityMap|0|LINK|mutability|MUTABLE|url|http://code.google.com/p/mysql-cacti-templates/^0|2|D|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@$A|L|B|M|1|N]]|C|$]]]|D|$E|$5|F|G|H|C|$I|J]]]]

Try <a href="http://code.google.com/p/mysql-cacti-templates/" rel="nofollow noreferrer">MySQL Cacti Templates</a>.

blocks|key|294279|text|mytop提供了一些方便的CLI信息，它是免费的(*unix+)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

mytop provides some handy CLI info, it's free (*unix only).

blocks|key|4033092|text|Mysql有一个名为Mysql管理员的免费工具，它是mysql工具包的一部分。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4033093|Mysql连接文档。|4033094|还有，它具有更多的监视功能。您可以监视其他服务器上的Mysql，请参阅常见问题7。|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/administrator/en/index.html|1|http://dev.mysql.com/doc/administrator/en/mysql-gui-options-connections.html|2|http://www.mysql.com/products/enterprise/faq.html#29^0|A|8|0|0|7|2|1|0|Z|5|2^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]]|H|$I|$5|J|K|L|C|$M|N]]|O|$5|J|K|L|C|$M|P]]|Q|$5|J|K|L|C|$M|R]]]]

Mysql has a free one called <a href="http://dev.mysql.com/doc/administrator/en/index.html" rel="nofollow noreferrer">Mysql Administrator</a> which is part of the mysql GUI tools package. 

Mysql Administrator connection <a href="http://dev.mysql.com/doc/administrator/en/mysql-gui-options-connections.html" rel="nofollow noreferrer">documentation</a>. 

There is also the Mysql Enterprise Monitor which has many more monitoring features. You can monitor Mysql on other servers see <a href="http://www.mysql.com/products/enterprise/faq.html#29" rel="nofollow noreferrer">faq question 7</a>.

blocks|key|294492|text|我喜欢SQLyog来远程管理mySQL。不错的GUI环境，还有一个免费的社区版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|294493|这家公司还生产MONyog，一种mySQL监控解决方案，但它不是免费的，我也没有玩过它。|entityMap|0|LINK|mutability|MUTABLE|url|http://www.webyog.com/en/^0|3|6|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@$A|N|B|O|1|P]]|C|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|C|$]]]|F|$G|$5|H|I|J|C|$K|L]]]]

I like <a href="http://www.webyog.com/en/" rel="nofollow noreferrer">SQLyog</a> for remote administration of mySQL. Nice GUI environment, and there is a free community edition.

This company also makes MONyog, a mySQL monitoring solution, but it's not free and I haven't played with it.

blocks|key|294547|text|我有一个自定义的Zabbix配置，用于从MySQL中提取有用的数据点。我应该把这些脚本向社区打开。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

I have a custom Zabbix configuration for extracting useful data points from MySQL. I should get around to opening these scripts up to the community.

blocks|key|294575|text|除了运行仙人掌来绘制mysql的性能随时间推移，我们有mysqltuner.com设置发送给我们的服务器上的任何变量的每日报告，我们应该密切关注。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|entityMap|0|LINK|mutability|MUTABLE|url|http://mysqltuner.com/^0|R|E|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@$A|L|B|M|1|N]]|C|$]]]|D|$E|$5|F|G|H|C|$I|J]]]]

Apart from running cacti to graph the mysql performance over time, we have <a href="http://mysqltuner.com" rel="nofollow noreferrer">mysqltuner.com</a> setup to send us a daily report of any variables on the server we should be keeping an eye on.

blocks|key|294674|text|innotop在监控方面做得很好。我相信这在high+performance+mysql的两个版本中都是推荐的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|entityMap^0|0|7|M|M^^$0|@$1|2|3|4|5|6|7|G|8|@$9|H|A|I|B|C]|$9|J|A|K|B|C]]|D|@]|E|$]]]|F|$]]

<code>innotop</code> has been fantastic for monitoring. i believe its recommended in both editions of <code>high performance mysql</code>.

blocks|key|294844|text|虽然它是最基本的，但我使用了：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|294845|$+watch+-n1+"mysqladmin+processlist+-u+root+-pYouWillNeverGuessThis"|code-block|syntax|javascript|294846|这为我提供了连接、用户、主机、数据库、命令等的列表，每秒钟更新一次。这是一个实时的“谁现在在做什么？”解决方案。|294847|很简单，但也很有用。|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|M|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|N|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|O|8|@]|9|@]|A|$]]]|K|$]]

As basic as it is, I've used:

<pre><code>$ watch -n1 "mysqladmin processlist -u root -pYouWillNeverGuessThis"
</code></pre>

This provides me with a list of connections, users, hosts, databases, commands etc, updated every second. It's a real-time "who's doing what right now?" solution.

Very simple, but also useful.

blocks|key|294457|text|我使用mysqladmin+processlist每5分钟运行一次cron作业。另见这个问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|294458|此外，phpMyAdmin还具有一些监视功能。|entityMap|0|LINK|mutability|MUTABLE|url|https://serverfault.com/questions/418/how-do-you-track-and-debug-mysql-performance-issues|1|http://www.phpmyadmin.net/home_page/index.php^0|3|M|16|4|0|0|3|A|1^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@$9|T|A|U|1|V]]|E|$]]|$1|F|3|G|5|6|7|W|8|@]|D|@$9|X|A|Y|1|Z]]|E|$]]]|H|$I|$5|J|K|L|E|$M|N]]|O|$5|J|K|L|E|$M|P]]]]

I use a cronjob running every 5 minutes with <code>mysqladmin processlist</code>. See also <a href="https://serverfault.com/questions/418/how-do-you-track-and-debug-mysql-performance-issues">this question</a> .

In addition, <a href="http://www.phpmyadmin.net/home_page/index.php" rel="nofollow noreferrer">phpMyAdmin</a> has some monitoring features.

blocks|key|4033308|text|我们使用过激，它是一个开放源码的应用程序，但是如果您愿意的话，也有一个商业产品。它还监视操作系统、web服务器等。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|entityMap|0|LINK|mutability|MUTABLE|url|http://hyperic-hq.sourceforge.net/^0|4|2|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@$A|L|B|M|1|N]]|C|$]]]|D|$E|$5|F|G|H|C|$I|J]]]]

We use <a href="http://hyperic-hq.sourceforge.net/" rel="nofollow noreferrer">hyperic</a>, it is an open source application, but there is a commercial product as well if you want. It also monitors the operating system, web servers etc.

blocks|key|294650|text|不要忘记监视底层平台。我会监视|type|unstyled|depth|inlineStyleRanges|entityRanges|data|294651|日志、数据和tmp设备上的IOPS+(您有三个独立的LUN上的IOPS，不是吗?)|unordered-list-item|294652|交换(超过几页/秒对mysql不利，用谷歌"mysql交换“来找出原因)|294653|主机操作系统的内存统计。我遵循的一般经验规则是，不超过80%25分配给mysql进程，以便为OS和缓冲区缓存留出一些空间。|294654|您可以使用SNMP和Cacti来监视所有这些事情。|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|M|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|N|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]]|K|$]]

Don't forget to monitor the underlying platform. I would monitor

<ul>
<li>IOPS on the log, data and tmp devices (you do have those on three seperate LUNs don't you ?)</li>
<li>Swapping (more than a few pages / second is bad for mysql, google "mysql swappiness" to find out why)</li>
<li>Memory statistics for the host OS. A general rule of thumb I follow is to allocate no more than 80% to the mysql process to leave some room for the OS and the buffer cache</li>
</ul>

You can use SNMP and Cacti to monitor all of these things

blocks|key|4033428|text|mtop很适合监视当前运行的查询和系统变量。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

mtop is great for monitoring current running queries and system variables.

blocks|key|294686|text|如上所述，仙人掌。同时我的顶有时也监测当前的活动。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

Cacti, as mentioned above. Also mytop sometimes to monitor current activity.

blocks|key|294747|text|通过纳古斯+nagios_mysql插件进行基本监控，增加了一个小的自定义脚本来监视奴隶状态和奴隶状态。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|entityMap|0|LINK|mutability|MUTABLE|url|http://www.nagios.org/^0|2|3|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@$A|L|B|M|1|N]]|C|$]]]|D|$E|$5|F|G|H|C|$I|J]]]]

Basic monitoring via the <a href="http://www.nagios.org/" rel="nofollow noreferrer">nagios</a> nagios_mysql plugin, added a small custom script to monitor slaves status and slavelag.

blocks|key|4033522|text|它并不是严格的监视，但您可以使用mysqlreport很好地概述mysql服务器的性能，以及它是否配置正确。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4033523|http://hackmysql.com/mysqlreport|offset|length|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|W|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@$D|N|E|O|1|P]]|A|$]]]|F|$G|$5|H|I|J|A|$K|C]]]]

It's not strictly monitoring but you can use mysqlreport to have a good overview of how well your mysql server is performing and if it is properly configured.

<a href="http://hackmysql.com/mysqlreport" rel="nofollow noreferrer">http://hackmysql.com/mysqlreport</a>

blocks|key|4033623|text|实际上，它取决于服务器上运行的数据库(S)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4033624|我通常会查一下|4033625|查询数|unordered-list-item|4033626|取决于数据库|4033627|4033628|索引|4033629|慢速查询日志|4033630|麦斯平|4033631|从远程主机到特定数据库的mysql连接|4033632|检查它是否在正确的主机上工作。|4033633|检查它是否从正确的主机失败。|4033634|4033635|选择当前时间以确保其正确|4033636|为排序规则/编码选择|4033637|连通用户|4033638|在框架方面，我将munin用于提供度量标准的所有内容，而nagios+(很快将成为冰冰)用于提供状态信息的所有内容。|offset|length|entityMap|0|LINK|mutability|MUTABLE|url|http://www.icinga.org/^0|0|0|1|1|0|0|0|0|1|1|1|0|0|0|0|15|2|0^^$0|@$1|2|3|4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1E|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1F|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|1G|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|J|3|K|5|F|7|1I|8|@]|9|@]|A|$]]|$1|L|3|M|5|F|7|1J|8|@]|9|@]|A|$]]|$1|N|3|O|5|F|7|1K|8|@]|9|@]|A|$]]|$1|P|3|Q|5|F|7|1L|8|@]|9|@]|A|$]]|$1|R|3|S|5|F|7|1M|8|@]|9|@]|A|$]]|$1|T|3|U|5|F|7|1N|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|W|3|X|5|F|7|1P|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1Q|8|@]|9|@]|A|$]]|$1|10|3|11|5|F|7|1R|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|1S|8|@]|9|@$14|1T|15|1U|1|1V]]|A|$]]]|16|$17|$5|18|19|1A|A|$1B|1C]]]]

Actually it depends on the database(s) that is running on the sever.

I usually check for the

<ul>
<li>number of queries

<ul>
<li>depending on database</li>
</ul></li>
<li>indexes</li>
<li>slow query log</li>
<li>mysqlping</li>
<li>mysql connection from a remote host to a certain database

<ul>
<li>check that it works from the right hosts</li>
<li>check that it fails from the right hosts</li>
</ul></li>
<li>select the current time to be sure it's correct</li>
<li>select for collations/encodings</li>
<li>connected users</li>
</ul>

on the framework side I'm using munin for everything that could give me metrics and nagios (soon to be <a href="http://www.icinga.org" rel="nofollow noreferrer">icinga</a>) for everything that gives me status information.

blocks|key|4033725|text|要想更全面地监视MySQL+(但是是商业的，所以只有当您的数据库值得的时候)，请查看www.LogicMonitor.com。不需要配置(检测存储引擎类型、复制状态等)；提供调优建议；在一个系统中提供完整的历史图表和警报；非常可扩展，并将监视数据中心基础结构的其余部分。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

For more comprehensive monitoring of MySQL (but commercial, so only if your database is worth it) check out www.LogicMonitor.com. No configuration required (detects storage engine types, replication status, etc); provides tuning recommendations; full historical graphing and alerting in one system; very extensible, and will monitor the rest of your datacenter infrastructure.

What tools do you use to monitor the health of your MySQL server instance? Are they for free or commercial?

MySQL monitoring tools

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

您使用哪些工具来监视MySQL服务器实例的运行情况？是免费的还是商业的？

问MySQL监控工具
EN

回答 17

Server Fault用户

Server Fault用户

Server Fault用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL监控工具EN

回答 17

Server Fault用户

Server Fault用户

Server Fault用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL监控工具
EN