Any strategies for a good, comprehensive coverage of MySql for somebody who's very experienced database-smart, but needs to obtain the MySql architecture, variations and peculiarities?
SQL in a Nutshell (3rd ed) is not precisely what you are asking about, however i think it is invaluable like a mention of the begin to see the various variations from ANSI standards for every of MySQL, PostgreSQL, Oracle, and SQL Server.
Amazon is loaded with lots of MySQL books you can test.
I am sure you'll say "I'm able to do an Amazon . com search", and you will be correct. "High End MySQL" sure looks good. It is the second one out there. Can you trust Amazon's calculations? We'll find out if you will find folks here who are able to second that opinion.
Understanding MySQL Internals and High Performance MySQL: Optimization, Backups, Replication, and More can be viewed as the definitive books on MySQL internals. Both are worth being read.