Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Recommended MySQL tuning utility for Windows

Tags:

performance

mysql

windows

iis

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?

Kind regards

like image 735
Hector Avatar asked Jul 26 '11 16:07

Hector

People also ask

What is the benefit of MySQL performance tuning for database?

MySQL performance tuning tools can help database professionals quickly identify bottlenecks, target insufficient operations through a review of query execution plans, and eliminate any guessing games.

What is MySQLTuner PL?

MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.

1 Answers

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.

like image 74
Peter Avatar answered Oct 28 '22 10:10

Peter
Sign in to Comment

Related questions

MySQL: averaging with nulls
SELECT * FROM tbl WHERE clm LIKE CONCAT('%',<other sql query LIMIT 1>,'%') - HOW?
How do I install the Rails MySQL adapter?
Setting Django/MySQL site to use UTF-8
Return Single Field with Rails Query
How do I add a total as the last row in my sql?
Cannot pass parameter 2 by reference - uuid PDO
Access Denied for MYSQL ERROR 1045
SQL getting max id field on a LEFT JOIN
Deadlock vs Lockwait Timeout on MySQL [closed]
c3p0 maxIdleTime is same as wait_timeout of mysql?
Not able to use mysql2 gem with Rails 4.1.5 in RubyMine
MySQL Unrecognized Keyword near CASE
How to import mysqlclient in python3 [duplicate]
Hibernate - unable to find Entity with ID
Can't connect to db from docker container [duplicate]
Is there a mysql function that will format a unix timestamp?
What is the best way to use number format in a MySQL query?
SQL: select all unique values in table A which are not in table B
How to connect Django to a MySQL database over an SSL connection?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!