The following error is seen when attempting to optimize/analyze any MySQL database:
Creating index 'PRIMARY' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again.
Open the $SPECROOT/mysql/my-spectrum.cnf file in text editor.
Add the line:
This value is in bytes. Default value is ~138MB.
Save and restart MySQL Service.