From: Date: July 23 2004 7:54pm
Subject: Suggested settings for dual processor machine?
List-Archive: http://lists.mysql.com/win32/15244
Message-Id: <032f01c470de$0ad9c0f0$46e17143@dual600>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Subject: Suggested settings for dual processor machine?


> I am running mySQL on a : (4.0.20 win32)
>
> Dual 2gig AMD (2 processors) under Windows 2000 with 2 gigs of memory
> Disk wise I am using a 7800rpm SATA (150mb/sec) drive+card (not on the OS
> drive)
> Can someone suggest things to change in mySQL setup to better utilize the
> 2gigs of memory and 2 processors...
>
> Also I am using :
>
> database service mysqld-nt, would it be better to use mysqld-nt-max or
> another type?
> database type myISAM, is this the fastest operating database? (im not
using
> fulltext index)
>
> Any help would be greatly appreciated...
>
> Thanks,
> Craig