This doesn't directly answer the question, but here's my 2 cents from a few high-volume MySQL/Web shops on the memory engine...
The decision tree is often like this: If you need the data to persist, put it in MySQL (probably InnoDB) and replicate it. If you need FAST access, put it in memcached. If you need FAST access and persistence, use MySQL behind memcached. You probably didn't need to do SQL queries anyway. Now I know that's an over-simplification, but it's something I've seen time and again. If the world suddenly had lots of 128GB servers, and a memory engine that scaled *really well* on multi-core, and could handle key lookups and range scans, *and* (this is the kicker) had an on-disk journal or some sort of built-in persistence... that might be different. It's interesting that a couple of the new appliance vendors at the MySQL Conference used the same basic hardware to build BOTH memcached and MySQL/InnoDB appliances. Makes you wonder what'd happen if drizzle had a memcached protocol plugin and was running on a box with SSD storage, etc... :-) Jeremy On Mon, Apr 27, 2009 at 11:51 AM, Brian Aker <[email protected]> wrote: > Hi! > > Has anyone ever done any sort of benchmarks on the B-tree indexes on the > Memory engine? Are people using them or are they just sticking to the > default HASH indexes? > > Two reasons I am asking: > 1) It would be simple to improve performance for the HEAP indexes, but the > B-tree are much more problematic. > 2) Are there any outstanding users of this feature? Or is this untested at > large? > > We badly need a new memory engine, it is high on my list. We can get a bit > more out of the current design but it would mean dropping functionality/etc. > > Cheers, > -Brian > > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
