Re: Server Sizing?

[Lance Rizzo]

There's really no magic answer on this one. Are you expecting tons of simultaneous users? Is this a dedicated machine? Is the processor hyperthreaded? BLOBs that size are perfectly suitable for database storage. If you get much large, storing on disk would likely increase performance, but that's not always true.

If it's going to be just a document store, and the queries are relatively simple, adding more memory and extensively utilizing MySQL's excellent caching capabilities would give you a lot of milage. Processor power, in that instance, may not be that critical. An intelligently indexed implementation can dramatically alter processor requirements.

I highly recommend "High Performance MySQL" by Zawodny. It's a quick read and covers many issues you may want to consider.

Hope this helps!