Syntax:
DROP LOGFILE GROUP logfile_group
    ENGINE [=] engine_name

This statement drops the log file group named logfile_group. The log
file group must already exist or an error results. (For information on
creating log file groups, see [HELP CREATE LOGFILE GROUP].)

*Important*: Before dropping a log file group, you must drop all
tablespaces that use that log file group for UNDO logging.

The required ENGINE clause provides the name of the storage engine used
by the log file group to be dropped. In MySQL 5.1, the only permitted
values for engine_name are NDB and NDBCLUSTER.

DROP LOGFILE GROUP was added in MySQL 5.1.6. In MySQL 5.1, it is useful
only with Disk Data storage for MySQL Cluster. See
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data.html.

URL: http://dev.mysql.com/doc/refman/5.1/en/drop-logfile-group.html

