Isn't MyISAM still the default over there?
Yes, it's the default.Personnally I compile MySQL without InnoDB... and for any new development I use postgres.
It's hardly likely that the average MySQL user would use anything but the default table type ...
Double yes ; also many hosts provide MySQL 4.0 or even 3.x, both of which have no subquery support and are really brain-dead ; and most OSS PHP apps have to be compatible... argh.