top | item 1140740

(no title)

mjrusso | 16 years ago

The first bottleneck on the MySQL set-up is the reading, not the writing. Even with the indices stored entirely in RAM (as the author pointed out in his blog post), the MySQL box can't keep up. (Consider the workflow of a software system that needs to parse hundreds of thousands of feeds on a continual basis. Each feed you download will have dozens of entries, and most of the time you'll have already processed the entry, so it can be ignored -- but the only way to know is to do a look-up.)

Regardless, A 68GB EC2 instance costs ~$1700/month. Four 2GB slices on Slicehost are priced at $520/month, with the cheaper set-up performing significantly better.

discuss

order

boundlessdreamz|16 years ago

Can you explain/give pointers as to how the indices can be stored entirely in ram ?

julien|16 years ago

I think the only way to is add RAM when your indices grow.. that's what we did up until now. There is absolutely now way a data store to keep this kind of performance as soon as you involve a disk, so, yes, the secret of whatever datastore is to _always_ keep everything in memory.