It will definately break somethings if you have a lot of accounts. MySQL 5 has some special features and they both deal with some of the more complex queries slightly. If are more than likely to get into a problem - if you're not sure you need the MySQL 5 features for your application. You won't get any special performance increase unless you're wanting to take advantage of the those mysql 5 specific features.
BLUETRIDENT.NET - Reliable Shared, Reseller and Dedicated Hosting Solutions Provider
Managed Hosting with Personal Service
Highspeed Content Servers, Lighttpd, Ruby on Rails, Cluster Servers & Rich Web Application Hosting