Jeremy Zawodny has written an article for Linux Magazine that does a great job explaining why MySQL 4.x is so nice.