Any MySQLTuner equivalent/alternative for Windows?

2.9k views Asked by At

I know auto tuning has its limits, but it would be great to quickly determine reasonable starting points for my Windows MySQL InnoDB configuration (innodb_additional_mem_pool_size, innodb_buffer_pool_size, innodb_log_file_size, innodb_log_buffer_size), given the RAM that I want to allocate to MySQL (512 Mo from a total 4 GB installed). I found this previous similar question but it had no answer.

Your help is much appreciated!

1

There are 1 answers

0
Peter On BEST ANSWER

I faced the same problem as you, so have ported MySQLTuner to Windows - you can download it from http://mysqltuner.codeplex.com/. The alternative is to run mysqltuner.pl from a Linux box, remote connecting to your Windows MySQL server, however this does not produce as accurate results.