MySql教程

MySQL binlog

本文主要是介绍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的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!