------=_NextPart_000_0013_01C4DE30.ADFEF420
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Will MYSQL Server performance improve considerably when using a SCSI =
drive instead of IDE? What kind of performance are we looking at?
Greg
------=_NextPart_000_0013_01C4DE30.ADFEF420--
Greetings,
It all depends on your system configuration and your server response
to that. If your server is constantly writting and reading from the
disc, you'll get better performance with a faster disc, but that's
all. If your MySQL server constantly write logs, have no indexes,
you'll get better performance.
Nowadays (that is a concept question) some people say SCSI drives are
gettings old, and that the new IDE drives with a lot or RPMs are
getting as fast as a SCSI disc. Some others keep saying SCSI is the
best for servers, but that is more related with RAID discs and
security than speed.
I sincerely hope I don't need to buy a SCSI adapter and a drive for my server...
Best regards,
On Thu, 9 Dec 2004 20:50:13 +0200, Greg Quinn
> Will MYSQL Server performance improve considerably when using a SCSI drive instead of IDE? What kind of performance are we looking at?
>
> Greg
>
>
--
Daniel da Veiga
Computer Operator - RS - Brazil
--
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
At 10:50 AM 09/12/2004, Greg Quinn wrote:
>Will MYSQL Server performance improve considerably when using a SCSI drive
>instead of IDE? What kind of performance are we looking at?
SCSI dick drives are potentially (depending on the makes and models
compared) built to a high standard than most IDE disk drives. This tends to
give them longer life.
SCSI in a single application/single thread environment is not any faster
than IDE drives at the same rotational speed and recording densities. In a
multitasking environment this is totally different.
SCSI has two interesting capabilities that favour the multitasking
environment: quick disconnect and reordered command sequencing. I don't
know why these have not found their way into the cheaper drives - probably
a more expensive design.
Quick disconnect (when using multiple SCSI drives) means that it can ask
one drive to seek to an address and quickly send or receive data to another
drive that has already reach its intended location. This is more important
for reads and synchronous writes than buffered operations.
Reordering commands can speed up disk throughput since it tends to reduce
the amount of needless address seeking. If the disk is positioned at
address 50 and the next command says go to address 10,000 and the following
command is to go to address 45, a SCSI disk will probably (timing does
matter) postpone the big jump and service the local request first.
Both of these features of SCSI can improve disk access speed. Then it comes
down to bus speeds with IDE still a little slower but SATA making the
grade. There have been promises to deliver SATA drives with reordering
command facilities but I don't know of any offering quick disconnect (ie
over lapping actives).
SCSI disks and controllers also tend to be "smarter" devices than plan old
IDE products. This can come into play with its ability to handle bad block
processing on its own.
In some ways it is a religious war although I have always used SCSI disk
drives for servers and IDE/ATA/SATA for workstations.
----------
Michael Burke
Cordova Bay Entertainment Group, Inc
2750 Quadra Street, Suite 209 250-658-0336 - Tel
Victoria, British Columbia 250-658-0593 - Fax
Canada V8T 4E8 www.cordovabay.com
(Cordova Bay Radio ---
--
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
Hi,
Greg Quinn wrote:
> Will MYSQL Server performance improve considerably when using a SCSI drive instead of IDE? What kind of performance are we looking at?
>
The moment the disk becomes the bottle-neck, an SCSI disk is really
faster. How much faster will depend on the data structure.
You could end with no visible difference and you could end even with
double the throughput.
There are still two factors where SCSI shines: raw data throughput and
seek time.
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