"mike thomas" [EMAIL PROTECTED] writes:
Greg,
Well, I'm doing like "%stuff%" selects on a single column table
with 20 million records, so any speed gain would be great. Would
I be correct in saying that a select of this type will always do
a table scan?
Pretty much.
I think I'll go
Hi,
I think I'll go with SCSI and increase the RAM so I can use a
heap table.
A cheap first step might be to go with a couple of decent 7200 rpm,
ATA100 (or whatever the hell they're calling themsevles this week)
disks and RAID0 them.
Striping Good.
Also, make sure your IDE is
Dave Hodgkinson wrote:
"mike thomas" [EMAIL PROTECTED] writes:
Greg,
Well, I'm doing like "%stuff%" selects on a single column table
with 20 million records, so any speed gain would be greatWould
I be correct in saying that a select of this type will always do
a table scan?
lto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 1:32 AM
To: mike thomas
Cc: Greg Cope; Mysql@Lists. Mysql. Com
Subject: Re: Should I switch to SCSI HD for mysql?
"mike thomas" [EMAIL PROTECTED]
writes:
Greg,
Well, I'm doing like "%stuff%" selects on a
single column
On Wed, Feb 07, 2001 at 06:24:58PM -0800, mike thomas wrote:
Hi all
I am running mysql on linux (redhat 6.2) using a regular 18Gb EIDI
hard drive. Does anyone know how much (ball park figure) a SCSI hard
drive would speed up selects and inserts?
That depends. Are your queryes CPU or disk
PROTECTED]
Subject: Re: Should I switch to SCSI HD for mysql?
On Wed, Feb 07, 2001 at 06:24:58PM -0800, mike thomas wrote:
Hi all
I am running mysql on linux (redhat 6.2) using a
regular 18Gb EIDI
hard drive. Does anyone know how much (ball park
figure) a SCSI hard
drive would speed up
e.
Thanks
Michael Thomas
-Original Message-
From: greg [mailto:greg]On Behalf Of Greg Cope
Sent: Wednesday, February 07, 2001 4:09 PM
To: mike thomas
Cc: Mysql@Lists. Mysql. Com; [EMAIL PROTECTED]
Subject: Re: Should I switch to SCSI HD for mysql?
mike thomas wrote:
Hi al
One thing to keep in mind is IDE tends to eat up processor power where as off board
scsi doesn't.
Greg Cope wrote:
mike thomas wrote:
Hi all
I am running mysql on linux (redhat 6.2) using a regular 18Gb
EIDI hard drive. Does anyone know how much (ball park figure) a
SCSI hard