Mysql二进制日志缓存参数

binlog_cache_size //事务缓存大小, 参数
binlog_cahce_use //事务缓存使用次数 状态
binblog_cache_disk_use //事务缓存磁盘使用次数(内存缓存设置过小不够用时) 状态
binlog_stmt_cache_size //非事务语句缓存大小 参数
binlog_stmt_cache_use //非事务语句缓存使用次数 状态
binlog_stmt_cache_disk_use //非事务语句磁盘缓存使用次数 状态

mysql> show global variables like 'binlog_cache%';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| binlog_cache_size | 32768 |
+-------------------+-------+
1 row in set (0.01 sec)

mysql> show global variables like '%binlog_stmt%';
+----------------------------+----------------------+
| Variable_name              | Value                |
+----------------------------+----------------------+
| binlog_stmt_cache_size     | 32768                |
| max_binlog_stmt_cache_size | 18446744073709547520 |
+----------------------------+----------------------+
2 rows in set (0.00 sec)

mysql> show status like "binlog_%";
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| Binlog_cache_disk_use      | 0     |
| Binlog_cache_use           | 0     |
| Binlog_stmt_cache_disk_use | 0     |
| Binlog_stmt_cache_use      | 0     |
+----------------------------+-------+
4 rows in set (0.00 sec)

grep 'binlog_cache' /etc/my.cnf
binlog_cache_size = 64M
max_binlog_cache_size = 128M
max_binlog_size = 200