Matt W wrote:
Hi Ted,
Heh. :-) This could be many GBs. There's no problem reading rows that
are in RAM (cached by the OS) -- can read over 10,000/second. If
there's enough RAM, the OS will take care of it (you could cat table.MYD
to /dev/null). No ramdisk necessary. :-)
BTW, this is for
Can anyone tell me whether or not some kind of RAID will improve the
seek/access times during lots of random reads from, say, MyISAM data
files? I *do not care* about improved [sequential] transfer rates; I
want the fastest possible random access.
RAID will only help reduce the average
Hi all,
Can anyone tell me whether or not some kind of RAID will improve the seek/access times
during lots of random reads from, say, MyISAM data files? I *do not care* about
improved [sequential] transfer rates; I want the fastest possible random access.
I'm thinking that RAID won't give an
Run everything off a ramdisk ;-)
Ted Gifford
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 5:21 PM
To: [EMAIL PROTECTED]
Subject: Improving seek/access times -- does RAID help?
Hi all,
Can anyone tell me whether or not some kind of RAID
-
From: [EMAIL PROTECTED]
Sent: Friday, February 20, 2004 7:24 PM
Subject: RE: Improving seek/access times -- does RAID help?
Run everything off a ramdisk ;-)
Ted Gifford
-Original Message-
From: Matt W
Sent: Friday, February 20, 2004 5:21 PM
Subject: Improving seek/access times
In the last episode (Feb 20), Matt W said:
Can anyone tell me whether or not some kind of RAID will improve the
seek/access times during lots of random reads from, say, MyISAM data
files? I *do not care* about improved [sequential] transfer rates; I
want the fastest possible random access.