This is a very good article about MySQL and Rails and some issues you can run into on high traffic apps. Most of these should be reserved for optimizations when there are issues. But they are good things to keep in mind.
The information about data scheme and indexes is very good think about when designing [...]
