Difference between revisions of "MySQL issues and solutions"
From DevOps Notebook
(Created page with "=== ERROR 1799 (HY000): Creating index 'PRIMARY' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again. === <pre> mysql> show varia...") |
|||
| Line 1: | Line 1: | ||
=== ERROR 1799 (HY000): Creating index 'PRIMARY' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again. === | === 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 | ||
<pre> | <pre> | ||
mysql> show variables like 'innodb_online%'; | mysql> show variables like 'innodb_online%'; | ||
| Line 8: | Line 9: | ||
+----------------------------------+------------+ | +----------------------------------+------------+ | ||
1 row in set (0.00 sec) | 1 row in set (0.00 sec) | ||
| + | |||
| + | mysql> SET GLOBAL innodb_online_alter_log_max_size=534217728; | ||
</pre> | </pre> | ||
Latest revision as of 14:34, 5 November 2020
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;
