I don't know how and what does PHP-nuke has to do with this thread, but anyways...
Anyone considering MySQL should read Why Not MySQL(http://www.openacs.org/why-not-mysql.html). It needs a bit updating, but most things there are still true.
Actually anyone considering MySQL should learn more about databases in general :)