Skip to content

Instantly share code, notes, and snippets.

@bhaskar-f22

bhaskar-f22/Reclaim_mysql_space.sql

Created July 15, 2021 08:06
Show Gist options
  • Save bhaskar-f22/ca39ab3e8f2c9f62ca0d1396d165d6ea to your computer and use it in GitHub Desktop.
Save bhaskar-f22/ca39ab3e8f2c9f62ca0d1396d165d6ea to your computer and use it in GitHub Desktop.
Download ZIP
Reclam unused space from DB
Raw
Reclaim_mysql_space.sql
-- First opthimize the table where you want to claim space
opthimize table <table-name>;
-- Delete logs except latest log file
show binary logs;
PURGE BINARY LOGS TO 'mysql-bin.006920';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment