Aikesheng Open Source Community

Apr 12, 2021 · Databases

Identifying and Cleaning Unused MySQL Tables Using ProxySQL Stats

This guide explains how to use ProxySQL's stats_mysql_query_digest to detect rarely accessed MySQL tables, export table lists, script the retrieval of last access times, and safely rename or drop unused tables after verification, helping reduce storage waste and metadata overhead.