13.1.28 DROP LOGFILE GROUP Statement语句

DROP LOGFILE GROUP logfile_group
    ENGINE [=] engine_name

This statement drops the log file group named logfile_group. 此语句删除名为logfile_group的日志文件组。The log file group must already exist or an error results. 日志文件组必须已存在，否则将导致错误。(For information on creating log file groups, see Section 13.1.16, “CREATE LOGFILE GROUP Statement”.)（有关创建日志文件组的信息，请参阅第13.1.16节，“CREATE LOGFILE GROUP语句”。）

Important重要

Before dropping a log file group, you must drop all tablespaces that use that log file group for UNDO logging.在删除日志文件组之前，必须删除使用该日志文件组进行UNDO日志记录的所有表空间。

The required ENGINE clause provides the name of the storage engine used by the log file group to be dropped. 必不可少的ENGINE子句提供要删除的日志文件组使用的存储引擎的名称。Currently, the only permitted values for engine_name are NDB and NDBCLUSTER.目前，engine_name的唯一允许值是NDB和NDBCLUSTER。

DROP LOGFILE GROUP is useful only with Disk Data storage for NDB Cluster. DROP LOGFILE GROUP仅适用于NDB群集的磁盘数据存储。See Section 23.5.10, “NDB Cluster Disk Data Tables”.请参阅第23.5.10节，“NDB群集磁盘数据表”。