问题描述：
[单选]
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:“allplicationdb”正在使用innoDB并消耗大量的文件系统空间。在存储备份的NFS上有一个/backup分区。您调查并收集以下信息：You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storting it on your backup partition．尝试将数据从mysqlu分区转储到mysqlu分区。Which set of actions will allow you to free disk space back to the file system？哪一组操作将允许您将磁盘空间释放回文件系统？
A．Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the file system: mysql> OPTIMIZE TABLE data_current, data_reports;
B．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: mysql> SET GLOBAL innodb_file_per_table=1; Mysql> ALTER TABLE data_current ENGINE=InnoDB; Mysql> ALTER TABLE data_repors ENGINE=InnoDB;
C．Take a backup, stop the server, remove the data files, and restore the backup: Shell> mysqldump –uroot –p applicationdb > /backup/applicationdb.sql Shell> /etc/init.d/mysql stop Shell> cd /var/lib/mysql/ Shell> rm ibdata1 ib_logfile0 ib_logfile1 Shell> /etc/init.d/mysql start Shell> mysql -u root –papplicationdb < /backup/applicationdb.sql
D．Enable compression on the table, causing InnoDB to release unused pages on disk to the file system: Mysql> SET GLOBLE innodb_file_per_table=1; Mysql> SET GLOBLE innodb_file_format=Barramcuda; Mysql> ALTER TABLE data_current ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; Mysql>ALTER TABLE data_history ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
参考答案：查看无
答案解析：无
☆收藏
答案解析：无
☆收藏
上一篇：A general purpose MySQL instance is configured with the following options( )（）通用MySQL实例配置如下选项( )--innodb-flush-log-at-trx-commit=1Which three statements are true？哪三种说法是正确的？
下一篇：You adjust a default configuration to the following /etc/my．cnf on a Linux installation( )您可以将默认配置调整为以下/etc/my．cnf 在Linux安装中( )You do not notice the spelling error in binrylog_format and restart your production server．How does the MySQL server behave with incorrectly spelled options？您没有注意到binrylog_格式的拼写错误，请重新启动生产服务员。怎么办MySQL服务器的选项拼写错误吗？
- 我要回答: 网友(216.73.216.168)
- 热门题目: 1.患者，女性，50岁，因右小腿 2.患者，女，9岁，左耳分泌性中 3.患者，男性，48岁，上前牙疼