MySQL issues and solutions

ERROR 1799 (HY000): Creating index 'PRIMARY' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again.

Check value (default 138MB) and increase it without restart

mysql> show variables like 'innodb_online%';
+----------------------------------+------------+
| Variable_name                    | Value      |
+----------------------------------+------------+
| innodb_online_alter_log_max_size | 134217728  |
+----------------------------------+------------+
1 row in set (0.00 sec)

mysql> SET GLOBAL innodb_online_alter_log_max_size=534217728;