MySQL Config Optimizations?

I am curious to know if anyone has advice on tweaking the out-of-the-box my.cnf specifically for Drupal?

The organization I work for typically hosts multisite installations, and may have numerous disparate sites running on a single web server using a single MySQL server... Given that there is a wide range of sites with varying purposes (some more anonymous viewing, some more authenticated content generation), are there any Drupal-specific changes to my.cnf which might be appropriate?

It seems to me that the table_cache value should be increased to a value which reflects both the number of tables as well as the amount of RAM.

The Query Cache is likely more useful on a predominantly anonymous-viewed site than on a site with a lot of authenticated user content generation. (http://groups.drupal.org/node/286233#comment-897508)

Chapter 8 of O'Rielly's High Performance MySQL suggests:

So what should you do? Make sure the basics such as the InnoDB buffer pool and log file size are appropriate, set a few safety and sanity options if you wish to prevent bad behavior (but note that these usually won’t improve performance—they’ll only avoid problems), and then leave the rest of the settings alone.

Does the question of Drupal-optimizations for MySQL make sense?

I have also raised this question in the High Performance group:
http://groups.drupal.org/node/286233#comment-897648