Monday, November 13, 2006

InnoDB not ſo bad

It is well know (at leaſt by the few people who know me at all) that I hate MySQL heartly — not only for its technical problems but for its intellectual diſhoneſty, at leaſt in talking about things they ſhould know better about.

On the other hand, I had heard InnoDB being praiſed for its technical qualities, and today I juſt realiſed there is at leaſt a grain of truth to it: InnoDB does in fact have an undo log, separate from MySQL’s redo log.

Granted, this does nothing to heal the problems about MySQL not being actually a DBMS (it is just a deviant, pſeudo-SQL interface for ſeveral different backends, of which InnoDB is juſt one and may be deprecated in the near future), and thus being too complex (I had to dig for this particular piece of information about logging, because InnoDB’s documentation iſn’t actually well integrated into MySQL’s, and can’t be and won’t ever be).

And as InnoDB has been acquired by Oracle, it neither ſays anything about MySQL’s future; indeed, their attemps to ſubſtitute for InnoDB seem feeble at best, and downright miſguided at worſt.