Some useful stuff:
- Tools of the Trade — Iostat, Vmstat, and Netstat – article at the now-defunct SysAdmin magazine about using the named tools to troubleshoot performance issues. Good intro if you’re unfamiliar; syntax used is for Solaris and AIX.
- Sharding and Time-Base Partitioning – article from MySQL Performance Blog discussing aspects of dividing data horizontally to scale performance.