Is there any reason not to use InnoDB by default?

[pauamma]

I just noticed that $LJ::USE_INNODB isn't listed in etc/config*, doc/config*, or cgi-bin/ljdefaults.pl. Before I file a bug, a question: is there any reason why the default/initial/suggested value should remain to the current "don't use it"?

Comments

[pauamma]

Are you thinking of other MySQL storage engines? (I don't see any engine that would offer obvious advantages listed on that page.) Or (since MySQL is now owned by Sun Oracle), were you thinking of other database servers? (The first that comes to my mind is PostgreSQL, but there may be others worth looking at in that case.)

[mark]

Actually I was thinking of something even stranger -- MariaDB or Drizzle. Both done by people who have been involved in the MySQL world rather intimately, and both carry a lot of that same ethos.

They're similar, especially in the case of MariaDB, but the difference is that they're still independent projects and are gaining a lot of traction in the open source world. They're not Corporate Zomg Projects.

OTOH, MySQL will work for a long time to come I bet and it's so widely supported...

[denise]

I'm actually listening to a lightning talk about MongoDB right now!