1. Home
  2. Infobright基础手册
  3. Infobright删除数据测试

Infobright删除数据测试

我们对三个引擎的表进行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>

这篇文档是否帮助到了您?