is there a script/program that I can run for mysql server 5.5 running on windows server 2008 to help optimize the server performance?

the system specs: 2 es5620 @ 2.40 ghz processers (4 cores each) 24 g/b ram x64 server 2008 R2 15k hdd x4 configured using raid 10 (data) 15k hdd x2 configured using raid 1 (system)

any help on maxing performance is appreciated! founds lot for linux, but not much for windows server 08 r2


Using MySQL 5.5.9, 5.5.11 in production Linux environments, here are my observations for using the InnoDB Buffer Pool, handling BLOBs, Setting Caches, Diskspace Usage and other assorted rantings . It applies just as much in Windows.


Try https://github.com/rackerhacker/MySQLTuner-perl. But that depends on perl being installed.. otherwise you will have to read the code and try the parameters and mysql commands on the mysql cli

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.