Innodb & Apache Module

[AllCdnBoy]

I read on the mysql site that Innodb is much faster than a regular table, yet when i see optimization replies, they all say to 'skip-innodb' ... what am i missing.

Also, i know that running PHP as an apache module instead of a CGI is supposed to be faster, but i really don't know the trade-offs ... and, how much faster is it really?

[Erwin]

You add skip-innodb to your my.cnf if you don't have any InnoDB tables - no need to check.

InnoDB tables are not necessarily faster - they are generally larger, and the real advantage is that they support row-level locking whether MyISAM has table-locking. However, they do not support full-text (at the moment).

Different databases have different outcomes with InnoDB - my forums had higher server loads with InnoDB but row-level locking was good.