Experience with upgrade to Linux 4GB RAM from Windows 2003: what kernel which release to prefer?
- Date: Wed, 3 Jan 2007 22:46:45 +0200
- From: "Spyros J. Papantoniou" <sjpapa@xxxxxx>
- Subject: Experience with upgrade to Linux 4GB RAM from Windows 2003: what kernel which release to prefer?
Dear mySQLers,
We are currently running into performance problems as the database gets bigger: 3.2 million rows, 1.3GB innodb file size on a proliant ML360 G4 machine with 2 3GHz CPUS and 4GB RAM on Windows 2003 server RAID1. recently upgraded to 5.0.27 [starting from 4.x in 2005].
How much would the performance increase if we were to change to Linux on the same box in order to exploit the full 4GB RAM? [Windows uses only 1.7GB per process, hence 60% of RAM are useless]. Is it worth the effort and downtime cost? What are the proper settings on my.cnf? [ the big my.cnf for 4GB RAM needs some tuning, the version on the release does not run as is]
Which Linux release shall we choose? SUSE or RedHAT? any particular pros or cons?
What is the proper 2.6 kernel? the standard or the big-smp with PAE?
Any working with this configuration that may share his views?
Many thanks in advance!