PlanetScale

Safely dropping MySQL tables

Jul 25, 2022David Graham
Safely dropping MySQL tables
SummaryAI, from the source post

This post introduces a feature within PlanetScale's deploy requests that warns users if a table they intend to drop has been recently queried. It also details how PlanetScale Insights can be used to identify table usage by filtering queries with `table:<name>` syntax and by leveraging SQL comment tags to trace query origins, thereby enabling safer table drops.

More from the Database Benchmarking Best Practices trail