The point Christophe made about lack of prefix compression in keys is especially important. I think this is a common enough layer concern that it should probably become an optional storage engine feature someday (as discussed here: Discussion thread for new storage engine ideas).
2 Likes