CentOS 7.x mariadb reclaiming space freed by deleting table rows

Home > CentOS > CentOS 7.x > Databases > MariaDB > CentOS 7.x mariadb reclaiming space freed by deleting table rows

Deleting rows from existing MySQL table may not directly free up used space on hard-disk. To free up disk space after deleting some rows of use:

   optimize table <table-name>

Refer:

• https://www.percona.com/blog/2013/09/25/how-to-reclaim-space-in-innodb-when-innodb_file_per_table-is-on/

Home > CentOS > CentOS 7.x > Databases > MariaDB > CentOS 7.x mariadb reclaiming space freed by deleting table rows