Windows 的 Mysql 调优/性能 [英] Mysql tuning/performance for windows

问题描述

我们将 mysql 5.0.27 版用于基于 Windows 的环境中的桌面应用程序.我们需要一个在 Windows 上运行并且可以监控 mysql 和查询的工具(希望是免费的)，以便我们能够修复一些慢查询并调整其性能.

We use mysql version 5.0.27 for a desktop application on a windows based environment. We need a tool (hopefully free) that runs on windows and that can monitor mysql and the queries so that we can hopefully fix some of the slow queries we have on it and tune its performance.

你会推荐什么?我在网上找到的脚本/perl 等不符合我们需要的东西.

What would you reccomend? the things i found online where scripts/perl etc that dont fit with our needs.

感谢您的帮助.

推荐答案

这个问题呼之欲出MySQL 查询代理.这是一个简单的程序，可以监控和分析客户端和服务器之间的通信.

That question shouts for the MySQL Query Proxy. This is a simple program that can monitor and analyze the communication between client and server.

它适用于不同的操作系统，其中之一是 Windows.它处于开发的早期阶段，但应该可以用于您提到的目的.

It is available for different OS, one of them Windows. It is in its early stages of development, but should be usable for the purpose you've mentioned.

这篇关于Windows 的 Mysql 调优/性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！