MySQL doesn't do subqueries, nor does it implement commit/rollback (and a host of other features, but I sure would miss these two were I required to use it).

It's great if you consider it as flatfiles-on-steroids, which is what the gist of this benchmark seems to be about. On the other hand, if you're looking at MySQL as an Oracle-on-the cheap, then there's a good article on why that is a Bad Idea.

PosgreSQL forever!