The `allplicationdb' 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 the…

The `allplicationdb' 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 the following information:

[mysqld] Datadir=/var/lib/mysql/ Innodb_file_per_table=0 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.

Shell> is -1 /var/lib/mysql/ -rw-rw---- 1 mysql mysql 744G Aug 26 14:34 ibdata1 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile0 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile1 ... You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storting it on your backup partition. Shell> mysqldump u root p applicationdb data_archive > /backup/data_archive.sql \Mysql> DROP TABLE data_archive; Which set of actions will allow you to free disk space back to the file system?