0

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

2 Answers 2

3

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.

1

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .