mysql performance tuning, windows server 2008 R2

Question

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

score 3 · Accepted Answer · edited May 23 '17 at 12:41

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.

edited May 23 '17 at 12:41

Community

1

answered May 04 '11 at 16:17

RolandoMySQLDBA

16,364
3
47
80

Software Mechanic · Answer 2 · 2011-05-04T18:54:35.477

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

edited May 04 '11 at 18:54

answered May 04 '11 at 16:34

Software Mechanic

221
1
9

mysql performance tuning, windows server 2008 R2

2 Answers2