Personally I’ve only made very light use of MySQL 5.0.x, mostly to see what breaks when using strict mode. Others, like Jeremy Cole having been pushing it a little harder. Unfortunately Jeremy concludes that MySQL 5.0 is remarkably painful. Some of the new features in 5.0 still have issues.