Difference between revisions of "CentOS 7.x mariadb reclaiming space freed by deleting table rows"
From Notes_Wiki
(Created page with "<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 MySQ...") |
m |
||
Line 1: | Line 1: | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 7.x]] > [[CentOS 7.x databases|Databases]] > [[CentOS 7.x mariadb|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: | 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: | ||
Line 9: | Line 8: | ||
Refer: | Refer: | ||
* https://www.percona.com/blog/2013/09/25/how-to-reclaim-space-in-innodb-when-innodb_file_per_table-is-on/ | * https://www.percona.com/blog/2013/09/25/how-to-reclaim-space-in-innodb-when-innodb_file_per_table-is-on/ | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 7.x]] > [[CentOS 7.x databases|Databases]] > [[CentOS 7.x mariadb|MariaDB]] > [[CentOS 7.x mariadb reclaiming space freed by deleting table rows]] |
Latest revision as of 16:05, 28 August 2022
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:
Home > CentOS > CentOS 7.x > Databases > MariaDB > CentOS 7.x mariadb reclaiming space freed by deleting table rows