MySQL AB :: MySQL 5.0 Reference Manual :: 6.2.1 Optimizing Queries with EXPLAIN
assert_efficient_sql - O'Reilly Ruby
rails plugin that can detect inefficient queries in test cases
MySQL :: MySQL 5.0 Reference Manual :: 9.1.4 Connection Character Sets and Collations
MySQL :: Unicode and Other Funny Characters
toledo’s code blog » Blog Archive » Beware of Rails Optimistic Locking and MySQL
Get Ruby 1.9, Rails, MySQL and UTF-8 to Work Together
Monkey patch the mysql gem to return UTF-8 encoded strings
http://dbisyourfriend.heroku.com/
metautonomo.us » Blog Archive » Updating MySQL DATETIMEs for Rails 2.1 Time Zones
The new time zone features assume that the database is storing times in UTC, so if you’re currently storing times in the database in a zone other than UTC, you’ll need to migrate existing data to UTC.
Anatomy of a Crushing (Pinboard Blog)
John Ewart » MySQL, Sub-selects and IN()