On Aug 30, 2006, at 13:58 , Brandon Aiken wrote:
I haven't got any numbers (or a USB stick I can test with at the
moment)
but USB is going to be a bottleneck for read and write performance.
Unless you're accessing very small amounts of data or running small
queries, I would expect performance to be pretty poor.
Indeed, that's pretty much our scenario- a rack-mounted Linux box
storing mostly inconsequential data (auth creds) with a flash drive-
quasi-embedded, I guess.
If your data set is so small, why do you need a full RDBMS instead of
flat data/text files or SQLite? If you're not concerned about disk
media failure, why do you need a transactional DB? It seems like
putting a deadbolt on a screen door.
MySQL and SQLite have terrible concurrent performance with
transactions. We would also like to take advantage of database-level
replication instead of our fragile home-grown thing for load-sharing
and failover.
It might work just great for your device, of course, but I would not
expect it to scale well at all.
There are some things I can do- for example, fsync should probably
just be off. I guess I should simply go ahead and try it. Thanks for
the discussion!
-M
