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