The configuration community:
binlog_cache_size
Information
The size of the cache to hold the SQL statements for the binary log during a transaction. A binary log cache is allocated for each client if the server supports any transactional storage engines and starting from MySQL 4.1.2 if the server has the binary log enabled (--log-bin option). If you often use large multiple-statement transactions you can increase this cache size to get more performance. The Binlog_cache_use and Binlog_cache_disk_use status variables can be useful for tuning the size of this variable.
Syntax
Example



