Karta Larch - 2013-06-16

This is a script from:
https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl

However the author did not include Windows as an option for users.
In the version in the Scripts folder, WINDOWS is the only option and the above link should be used for Linux and other systems.

This is a script that will provide advice for general settings in my.cnf (or my.ini) and php.ini when used on LOCAL WINDOWS test systems such as XAMPP. This may be useful on remote Win IIS servers, but there is no way to test this option (nor real interest).

In order to use this you ust fire up a utility such as XAMPP-CONTROL and make sure MySQL is running. It is probably a good idea to have Apache running also).

The file should be in your \mySQL\Bin directory, or else that directory should be in your PATH.
Go to a Command Priompt :
START/RUN/cmd.exe
and then type:
echo %PATH%

if you dont see anything with \mySQL\Bin in it, then it myst be run from that directory.

to add the directory:
http://www.computerhope.com/issues/ch000549.htm

make sure you enter the COMPLETE path there;
;C:\XAMPP\MYSQL\BIN
as an example for XAMPP.

You WILL need PERL, so add that to your path if XAMPP didnt!
(it comes with XAMPP)

And you may need the Posix versions of a few free utilities like
free
which

There are packages of these utilties here:
http://www.cyberciti.biz/faq/unix-command-line-utilities-for-windows/

cygwin (which we use here) can be rather large, and users should only really download just BASE and UTILS. The entire kit is well over a GB and will also include server software (which can be used in place of XAMPP). however one *must8 check to see that \cygwin\bin is in the PATH, and if not, place it there with the instructions above.

potentially, alot of work to use a simple utlity but with the suggestions it provides, the setting may also be of use when the site goes live on a hosted server.