我们对三个引擎的表进行delete操作，执行时间如下所示，可以看到Infobright社区版不支持delete操作。

Innodb：

mysql> delete from gos_so2do_statistic_innodb;

Query OK, 10000000 rows affected (19 min 17.17 sec)

Myisam：

mysql> delete from gos_so2do_statistic_myisam;

Query OK, 10000000 rows affected (0.30 sec)

Brighthouse：

mysql> delete from gos_so2do_statistic_brighthouse;

ERROR 1031 (HY000): Table storage engine for ‘gos_so2do_statistic_brighthouse’ doesn’t have this option

mysql>