On Mon, Apr 27, 2009 at 2:51 PM, 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?
Jeremy gave you the high-volume craziness answer. I'll give you the "normative user" answer: nobody really uses B-tree indexes on MEMORY tables. Very few people use MEMORY tables in general, and those that do, use it because they have high-volume, volatile tables (ie, tables with user ID's for users who are online) and can't handle even the locking that InnoDB does. -Sheeri (based on my experiences, yadda yadda) > > 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 > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- - Sheeri K. Cabral http://tinyurl.com/mysqlbook will take you to the Amazon.com page for my upcoming book, "MySQL Administrator's Bible". _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
