MySQL binlog

binlog 的配置

 

mysql> show variables like ‘%binlog%‘;
+---------------------------------------------------+----------------------+
| Variable_name | Value |
+---------------------------------------------------+----------------------+
| binlog_cache_size | 2097152 |
| binlog_checksum | CRC32 |
| binlog_direct_non_transactional_updates | OFF |
| binlog_format | ROW |
| binlog_order_commits | ON |
| binlog_row_image | FULL |
| binlog_rows_query_log_events | OFF |
| binlog_stmt_cache_size | 32768 |
| innodb_api_enable_binlog | OFF |
| innodb_locks_unsafe_for_binlog | OFF |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 524288000 |
| max_binlog_stmt_cache_size | 18446744073709547520 |
| performance_point_transtat_binlog_bytes_threshold | 1048576 |
| sync_binlog | 1000 |
+---------------------------------------------------+----------------------

 

 

MySQL binlog

 

MySQL binlog

上一篇:mysql架构篇之主从结构


下一篇:数据库重要的是结构,用小学语句拆分,数据库题目也可以很简单