2

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!

Community
  • 1
  • 1
Erwin Mayer
  • 18,076
  • 9
  • 88
  • 126

1 Answers1

2

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.

Peter
  • 2,654
  • 2
  • 33
  • 44