MySQL Remote DBA — 24/7 Expert Support

Audits table storage allocation, index overhead, and queries sys.schema_unused_indexes to reclaim unneeded disk space and reduce buffer pool waste.

-- 1. Inspect top largest tables, index overhead, and data-free space
SELECT 
  table_schema, 
  table_name, 
  table_rows, 
  ROUND(data_length / 1024 / 1024 / 1024, 2) AS data_gb, 
  ROUND(index_length / 1024 / 1024 / 1024, 2) AS index_gb, 
  ROUND(data_free / 1024 / 1024 / 1024, 2) AS free_gb 
FROM information_schema.tables 
WHERE table_schema NOT IN ('mysql', 'information_schema', 'performance_schema', 'sys') 
ORDER BY (data_length + index_length) DESC 
LIMIT 10;

-- 2. Audit unused indexes consuming write overhead and memory
SELECT 
  object_schema, 
  object_name, 
  index_name 
FROM sys.schema_unused_indexes 
LIMIT 15;

Computes current binary log coordinates and validates global GTID purged boundaries to prevent replication resynchronization failures.

-- 1. Inspect active master binary log position and coordinates
SHOW MASTER STATUS;

-- 2. Validate current replica GTID purge safety boundary
SELECT @@GLOBAL.gtid_purged AS purged_gtids;