From: Date: July 20 2004 10:59am
Subject: Suggested settings for dual processor machine?
List-Archive: http://lists.mysql.com/win32/15196
Message-Id: <0f4b01c46e37$dc4b5e40$46e17143@dual600>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I am running mySQL on a :

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