1 of 1

Error 1197: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage

Error Code

SQLSTATE

Error

Description

1197

HY000

ER_TRANS_CACHE_FULL

Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again

Possible Causes and Solutions