You should take a look at the Tricks with DBI node by btrott; it goes into some detail about error codes with DBI.

MySQL should never "just die"; you might run into things like not being able to execute a bad SQL statement, but you should be able to get all the error details you need through the DBI module.