Tag

Unused Tables

0 views collected around this technical thread.

Aikesheng Open Source Community
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.

Database CleanupMySQLProxySQL
0 likes · 5 min read
Identifying and Cleaning Unused MySQL Tables Using ProxySQL Stats