On Jan 12, 2004, at 2:23 PM, Nick Hill wrote:
This would be cured by moving the database to solid
state memory.
Mechanical media has a very long seek time and when many seeks are
required, become unreliable.
Either:
Run two MySQL instances, one starting after the finest grained
database files have been copied to ramdisk. Replicate database to a
hard disk file.
I'm not sure how running two copies of MySQL on a machine is going to
be faster than running one. Plus,
I don't think MySQL can even work in this configuration.
Or
Install a solid state IDE disk. For example, a 4Gb Compact Flash card
has an IDE interface built in as part of the specifications. Access
time 0.1ms comapred to mechanical 8.5ms. 85x faster. CF to IDE cables
are trivial and available.
To put it another way, you would need 85 mechanical drives to provide
the seek performance of a solid state equivalent.
Hmm... 4GB Compact Flash cards would be:
Too small (4GB is not enough space, we would need a couple hundred
cards)
Too expensive (4GB cards cost approximately about $1100, or around
$330000 for enough space)
Too slow (fast access, but only a 5MB/sec read/write)
Limit read/writes (they would last about one week, and need to be
tossed out)
So, no.
--
Nick Reinking -- eschewing obfuscation since 1981 -- Minneapolis, MN