CentOS 7.x mariadb reclaiming space freed by deleting table rows
From Notes_Wiki
<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: