A couple of days ago I posted about scaling writes in mysql. I didn't
say much about read performance in that post because a) it was
irrelevant at the time, and b) there are thousands of articles
all over the web that already cover read performance.
In this post I'm going to cover some of the things that I did to
improve read performance for my own application. It may be
relevant to others, however, you'd still need to read a whole
bunch of other articles to understand MySQL read
performance.
Looking at our access patterns, it turned out that there were two
classes of read queries.
- Reads to build the daily summaries
- Reads from the summary tables in response to user actions
The former dealt with far more data at one go, but was only run once. Queries for this pattern were slow …
[Read more]