推荐用于 Windows 的 MySQL 调优实用程序
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6833397/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Recommended MySQL tuning utility for Windows
提问by Hector
I have been using MySQL Tuner (http://mysqltuner.com) on Linux for a while and am quite comfortable with it. Now, for whichever reason, we have had to start hosting other websites on IIS. Is there a similar tuning utility that may recommend config changes to MySQL on Windows Server 2008?
我已经在 Linux 上使用 MySQL Tuner (http://mysqltuner.com) 有一段时间了，并且对它非常满意。现在，无论出于何种原因，我们都不得不开始在 IIS 上托管其他网站。是否有类似的调整实用程序可以建议对 Windows Server 2008 上的 MySQL 进行配置更改？
Kind regards
亲切的问候
回答by Peter
I have just ported the mysqltuner.pl script to Windows - see http://mysqltuner.codeplex.com/. It uses the same checks as version 1.2 of the mysqltuner.pl script, but in a nice, friendly Windows application - no need to install Cygwin or Perl.
我刚刚将 mysqltuner.pl 脚本移植到 Windows - 请参阅http://mysqltuner.codeplex.com/。它使用与 mysqltuner.pl 脚本的 1.2 版相同的检查，但在一个漂亮、友好的 Windows 应用程序中 - 无需安装 Cygwin 或 Perl。
回答by Werner van der Vyver
Ok so this is over a year after the question but I thought it relevant because you can actually still use the mysqltuner script if you combine it with Cygwin.
好的，这是在提出问题一年多了，但我认为它相关，因为如果将 mysqltuner 脚本与 Cygwin 结合使用，实际上仍然可以使用它。
- Install Cygwin
- Make sure Perl is installed
Additionally I installed the mysql and the mysqld packages as well (Needed for the script to connect to a "remote" MySQL.
Copy the mysqltuner.plscript to your Cygwin user home directory (Found under cygwin_install_dir/home/your.user)
- Start the Cygwin terminal
- Run the script $ perl mysqltuner.pl --host mysql_host_ip --forcemem 512
- 安装 Cygwin
- 确保安装了 Perl
此外，我还安装了 mysql 和 mysqld 包（需要脚本连接到“远程”MySQL。
将mysqltuner.pl脚本复制到您的 Cygwin 用户主目录（在cygwin_install_dir/home/your.user下找到）
- 启动 Cygwin 终端
- 运行脚本$ perl mysqltuner.pl --host mysql_host_ip --forcemem 512
If you encounter an error in the line of: ERROR 1130 (HY000): Host 'somename.company.com' is not allowed to connect to this MySQL server
如果你在一行中遇到错误： ERROR 1130 (HY000): Host 'somename.company.com' is not allowed to connect to this MySQL server
Go to the database server and add the appropriate user and privelages
转到数据库服务器并添加适当的用户和权限
You should now be able to use mysqltunerin a windows environment against local as well as remote MySQL servers.
您现在应该能够在 Windows 环境中对本地和远程 MySQL 服务器使用mysqltuner。
...screenshots removed because I'm not allowed to use images yet, sorry.
...截图已删除，因为我还不允许使用图像，抱歉。
回答by daytabase
Don't know of another tool (outside the MySQL Instance Configuration Wizard you can run) like mysqltuner which will not run unfortunately. You can install Perl on Windows, but when run the .pl file you will get an error about $PATH not having mysqladmin in it. Upon reading of the manual laughing, it plain as day states there is no Windows support for 1.2.0 version of tool.
不知道还有其他工具（在您可以运行的 MySQL 实例配置向导之外），例如 mysqltuner，不幸的是它不会运行。您可以在 Windows 上安装 Perl，但是当运行 .pl 文件时，您将收到关于 $PATH 中没有 mysqladmin 的错误。看了手册笑了，很明显没有Windows支持1.2.0版本的工具。
You can see if these suggestions help in the interim: http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
您可以查看这些建议在此期间是否有帮助：http: //www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
Edit: I just found this: http://www.webyog.com/webyog/monyogscreenshotsMONyog, it is a paid product, though. I installed the trial and it looks very promising. It monitors your SQL server and gives you alerts and recommendations based on those alerts. Might be worth a look. I cannot vouch for too much other than it has some nice information in just a short period of time.
编辑：我刚刚发现这个：http: //www.webyog.com/webyog/monyogscreenshotsMONyog，不过它是付费产品。我安装了试用版，看起来很有希望。它监控您的 SQL 服务器，并根据这些警报为您提供警报和建议。可能值得一看。除了在短时间内提供一些不错的信息之外，我不能保证太多。
