MySQL
High server load because of repeating queries too many times
Reduce your server's resource usage by moving MySQL temporary directory to tmpfs
Presentation: HUGE! A Drupal site with 381 modules, 174GB MySQL database, and 200 million row tables
Fast, Parallel MySQL Backups and Imports with Mydumper
Bypassing Drupal core Node Access table joins to avoid outage caused by slow queries
