http://www.mysqlperformanceblog.com/2010/12/09/thinking-about-running-op... explains how the OPTIMIZE query on InnoDB queries is not at all efficient and offers an alternative method of optimizing InnoDB tables. One thing to investigate is whether to allow this module to optimize InnoDB tables at all since the proposed dropping and adding of keys in the performance blog might break foreign keys, from a comment on the blog:
The InnoDB plugin documentation says that altering foreign keys on tables will cause a table copy instead of fast index creation.
Closed: won't fix
1.0
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.