mysql performance with SCSI versus SATA hard disks

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

Hi,

=20

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

=20

Ila.

=20


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

RE: mysql performance with SCSI versus SATA hard disks

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@consentry.com]
Sent: Friday, April 28, 2006 2:03 PM
To: win32@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@m.gmane.org

Re: mysql performance with SCSI versus SATA hard disks

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@m.gmane.org