Transactions have only recently become available in MySQL, so they don't have much of a track record yet. Also, many who are biased against MySQL on the basis of no transactions haven't been keeping up with MySQL (not that there aren't other reasons to favor, say, Postgres.)