Recommended MySQL Tuning Utility for Windows

Question

I have been using MySQL Tuner (http://mysqltuner.com) on Linux for a while, and I find it very convenient. Now, for whatever reason, we had to start hosting other sites in IIS. Is there a similar configuration utility that can recommend MySQL configuration changes in Windows Server 2008?

respectfully

Answer 1

I 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 pleasant, friendly Windows application - there is no need to install Cygwin or Perl.

Answer 2

Okay, so more than a year has passed since the question, but I thought it was relevant because you can really use the mysqltuner script if you combine it with Cygwin.

• Install Cygwin
• Make sure Perl is installed

• In addition, I also installed the mysql and mysqld packages (necessary for the script to connect to the "remote" MySQL.
  

• Copy the mysqltuner.pl script to the Cygwin user home directory (found in the cygwin_install_dir / home / your.user section )

• Launch Cygwin Terminal
• Run the script $ perl mysqltuner.pl --host mysql_host_ip --forcemem 512

If you encounter an error in the line: 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 personal resources

Now you can use mysqltuner in a Windows environment for local and remote MySQL servers.

... screenshots removed because I am not yet allowed to use images, sorry.

Answer 3

I don’t know of another tool (with the exception of the MySQL instance setup wizard that you can run), like mysqltuner, which will not work, unfortunately. You can install Perl on Windows, but when you run the .pl file, you get the error message "$ PATH" without mysqladmin in it. After reading the manual laugh, as in the case of the day, there is no Windows support for version 1.2.0 of the tool.

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/

Edit: I just found this: http://www.webyog.com/webyog/monyogscreenshots However, MONyog is a paid product. I installed the trial version and looks very promising. It controls your SQL server and gives you warnings and recommendations based on these warnings. Maybe worth a look. I can not vouch for too much, except that he has good information in a short period of time.