Any MySQLTuner equivalent/alternative for Windows?
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!
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.
精彩评论