Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
add comment

2 Answers 2

up vote 3 down vote accepted

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.

share|improve this answer
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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