Pixelite
  • Home
  • Drupal
  • About
  • Contact
Subscribe
Tagged

MySQL

A collection of 3 posts

How many JOINs is too many? Tuning optimizer_search_depth for MySQL with Drupal
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.

  • Sean Hamlin
Sean Hamlin Mar 14, 2021 • 3 min read
Finding and killing long running SQL queries in AWS RDS
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.

  • Sean Hamlin
Sean Hamlin May 22, 2020 • 3 min read
Search API attachments and storing reasonable amounts of data
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.

  • Sean Hamlin
Sean Hamlin Nov 20, 2019 • 4 min read
Pixelite © 2025 Creative Commons Attribution-NonCommercial 4.0 International License
Facebook
Twitter
Powered by Ghost
Hosted by amazee.io