easy5 pts · first answer countspostgresqlmysqlmaintenance
Getting disk back from a MySQL table
In MySQL with innodb_file_per_table = ON, you deleted 70% of a table's rows but the .ibd file stays the same size. What returns the space to the OS?
Discussion 0
Join free to post in the discussion.
Related questions
- Logical vs physical backupDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- Read-only access for analystsDatabase Administrator
- What pg_hba.conf controlsDatabase Administrator
- View vs materialized viewDatabase Administrator
- Seeing what is running nowDatabase Administrator
- Cancel or terminate a sessionDatabase Administrator
- Why InnoDB over MyISAMDatabase Administrator