Re: Low-end SATA vs. SCSI

[Larry Lowry]

For cost reasons I use SATA.  Does the machine already 
have a SCSI card in it? If so I would use SCSI.  If not
I would give one of the newer 10k SATA drives a spin.

Larry
----- Original Message ----- 
From: "Fagyal Csongor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 12, 2004 12:03 PM
Subject: Low-end SATA vs. SCSI


Hi List,
I am putting in a separate disk for our MySQL (4.1.7) server. I have 
some MyISAM, some InnoDB tables. Lots of reads, lots of writes (mostly 
atomic ones, insert/update one row), a few million rows per table, 
approx. 100-400 queries per second.

What would you say is better (with respect to performance): a small SCSI 
disk (say 18G, 10kRPM) or a bigger SATA (say 120G, 7200RPM)?

Thank you for your feeback,
- Csongor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]