------_=_NextPart_001_01C66AEE.0AC9A268
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,



Can any one help out to know how mysql performs between SCSI and SATA
hard disks?



Ila.




------_=_NextPart_001_01C66AEE.0AC9A268--

Data Xfer is slightly faster with SCSI, but SATA handles data is larger
blocks. So if your fetches are relatively large SATA will out-perform SCSI.

-----Original Message-----
From: Ilavajuthy Palanisamy [mailto:ipalanisamy [at] consentry.com]
Sent: Friday, April 28, 2006 2:03 PM
To: win32 [at] lists.mysql.com
Subject: mysql performance with SCSI versus SATA hard disks

Hi,

Can any one help out to know how mysql performs between SCSI and SATA hard
disks?

Ila.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org

Hi,

Ilavajuthy Palanisamy wrote:
> Hi,
>
>
>
> Can any one help out to know how mysql performs between SCSI and SATA
> hard disks?

it depends on the drives. Nothing outperforms a 15k rpm drive with SCSI.

The larger the index files are the more the drive speed becomes important.

Nothing will cost you more than a 15k rpm drive with SCSI.

There is a pretty impressive difference between 10k rpm and 15k rpm drives.

So, if you really need the speed, there is not other option for you.

Erich

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org