The ‘applicationdb’ is using InnoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather this information:
Three tables are stored in the InnoDB shared tablespace and the details are as follows:
The table data_current has 1,000,000 rows.
The table data_reports has 1,500,000 rows.
The table data_archive has 4,500,000 rows.
You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storing it on your backup partition.
Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?
Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:
Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the file system:
Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:
Take a backup, stop the server, remove the data files, and restore the backup:
Submit