The real question for me is why MySQL, and not something more complete, like PostgreSQL? Are you not aware of PostgreSQL? Is it not installed on your system?
MySQL had its day. Now it's being left in the dust by PostgreSQL. There's no reason in my mind to continue to use MySQL except for legacy (software or people).
Update:
Take a look at the bullet list at the end of
http://advocacy.postgresql.org/advantages/ if you're not sure why I'm saying what I'm saying. Most of what you see there is not mature (if available at all) in MySQL. But the most particularly troublesome part of MySQL is the licensing. Once you are making money with MySQL somehow, you're almost certainly in the "commercial" category, and will have to pay hefty fees to "license" the non-personal version. PostgreSQL is BSD-style licensed, and is therefore truly free, to embed or adapt as you see fit.