mysql开始binlog会影响性能吗_【MySQL】binlog缓存的问题和性能

之前在没有备库的情况下，遇到过more than 'max_binlog_cache_size' bytes of storage 的错误，今天在主备复制的时候又遇到了这个问题

Last_SQL_Errno: 1197

Last_SQL_Error: Worker 14 failed executing transaction '' at master log mysql-bin.050101, end_log_pos 2669492980; Could not execute Delete_rows_v1 event on table time_dispatcher_0029.ttd_task_1889; Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again, Error_code: 1197; handler error HA_ERR_RBR_LOGGING_FAILED; the event's master log mysql-bin.050101, end_log_pos 2669492980

slave

root@(none) 10:11:38>show variables like '%binlog_%size%';

+----------------------------+----------------------+

| Variable_name | Value |

+----------------------------+----------------------+

| binlog_cache_size | 32768 |

| binlog_