MySQL error 1197, multi-statement transaction required more than ' max_binlog_cache_size ' bytes of storage; Increase this mysqld variable and try again workaround

Known as one of the most popular open source database, MySQL is widely used in various scenarios, ApsaraDB RDS for MySQL of Alibaba Cloud provided critical relief for companies, especially small and medium-sized enterprises affected by novel coronavirus (COVID-19).

SELECT @ @max_binlog_cache_size;

If a MySQL transaction requires more memory than max_binlog_cache_size;mysql it will throw multi-statement transaction required more than ' max_binlog_cache_s Ize ' ERROR.

Workaround:

SET GLOBAL max_binlog_cache_size = 4294967296; #40G

The recommended maximum setting is 40G,

The maximum possible setting is 16EB (exabytes),

MySQL error 1197, multi-statement transaction required more than ' max_binlog_cache_size ' bytes of storage; Increase this mysqld variable and try again workaround