@mattab opened this Issue on July 31st 2012 Member

Reported in forums

Innodb does not work well with OPTIMIZE statements, esp. on large tables. I suggest we do not run the OPTIMIZE statement when the table is Innodb.

Could we detect that the table is using Innodb?

The code is in optimizeTables() in /trunk/core/PluginsFunctions/Sql.php

@mattab commented on September 5th 2012 Member

let's add a new config option

[General]
; set to 0 when using Innodb tables in your database, because OPTIMIZE queries can take hours to run on very large Innodb tables
mysql_enable_optimize_tables = 1

@diosmosis commented on October 3rd 2012 Member

(In [7096]) Fixes #3289, don't optimize InnoDB tables.

@diosmosis commented on October 4th 2012 Member

(In [7098]) Refs #3289, change test name + filename.

This Issue was closed on October 4th 2012
Powered by GitHub Issue Mirror