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

<yambe:breadcrumb>CentOS_7.x_mariadb|CentOS 7.x mariadb</yambe:breadcrumb>

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/