Error about innodb_online_alter_log_max_size when optimizing database

Products

• CA Spectrum

Issue/Introduction

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.

Environment

Release:
Component: SPCCSS

Resolution

Open the $SPECROOT/mysql/my-spectrum.cnf file in text editor. 

Add the line: 

innodb_online_alter_log_max_size=500000000 

This value is in bytes. Default value is ~138MB. 

Save and restart MySQL Service.