Drupal How many JOINs is too many? Tuning optimizer_search_depth for MySQL with Drupal Drupal is extremely flexible, and creates a highly normalised table structure, 2 tables per field on a piece of content. We were seeing SQL queries appear to never complete when they had lots of JOINs in them.
MySQL Finding and killing long running SQL queries in AWS RDS Occasionally we find sites that are running extremely slowly, and digging down we end up finding MySQL queries that have been running, for sometimes days or even weeks.
Drupal Search API attachments and storing reasonable amounts of data Search API Attachments has a setting that allows you to store only the most important information in the database.