← Graph

MySQL Data Directory in RAM

takeaway 3 connections

Closing-Q&A dark-art trick: for a project stuck on MySQL because of a tightly-coupled Sphinx search engine, the speaker put the whole MySQL data directory in RAM via a single Docker Compose line. The test suite dropped from ~10 minutes to ~1–1.5 minutes. SQLite supports the same in-RAM mode.

type
lesson-learned
takeaway MySQL Data Directory in RAM
about
MySQL tool
Trick applies to MySQL run via Docker Compose.
takeaway MySQL Data Directory in RAM
about
Docker tool
Achieved by adding a single Docker Compose line mounting the data directory in RAM.
takeaway MySQL Data Directory in RAM
from_talk
Closing audience trick for MySQL/SQLite in-RAM test databases.

Provenance

Read by
2 extractions