重庆小潘seo博客

当前位置:首页 > 重庆网络营销 > 小潘杂谈 >

小潘杂谈

mac如何开启mysql bin-log

时间:2020-09-24 01:40:08 作者:重庆seo小潘 来源:
vim /usr/local/etc/my.cnf 添加以下配置expire_logs_days = 5 定期清理log-bin = /usr/local/var/mysql/mysql_bin_log/mysql-bin #开启binlog,指定文件闻之server_id = 1 #配置mysql replication需要定义,不能和canal的slaveId重复binlog_format=MIXEDDmys

vim /usr/local/etc/my.cnf 添加以下配置expire_logs_days = 5 定期清理log-bin = /usr/local/var/mysql/mysql_bin_log/mysql-bin #开启binlog,指定文件闻之server_id = 1 #配置mysql replication需要定义,不能和canal的slaveId重复binlog_format=MIXEDDmysql.server restart // 重启mysql

show variables like '%log_bin% 查看是否开启

show master status; 查看日志状态

flush logs; 刷新日志,刷新之后会新建一个新的Binlog日志

reset master 清空目录下所有日志文件

查看日志文件:mysqlbinlog --base64-output=DECODE-ROWS -v mysql-bin.000001/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;DELIMITER /*!*/;# at 4#200423 16:43:25 server id 1end_log_pos 123 CRC32 0xb303c132Start: binlog v 4, server v 5.7.29-log created 200423 16:43:25 at startup# Warning: this binlog is either in use or was not closed properly.ROLLBACK/*!*/;# at 123#200423 16:43:25 server id 1end_log_pos 154 CRC32 0x21d20383Previous-GTIDs# [empty]# at 154#200423 16:45:11 server id 1end_log_pos 219 CRC32 0xfb334efdAnonymous_GTIDlast_committed=0sequence_number=1rbr_only=noSET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;# at 219#200423 16:45:11 server id 1end_log_pos 295 CRC32 0xb8e6b396Querythread_id=4exec_time=0error_code=0SET TIMESTAMP=1587631511/*!*/;SET @@session.pseudo_thread_id=4/*!*/;SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;SET @@session.sql_mode=1436549152/*!*/;SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;/*!C utf8 *//*!*/;SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;SET @@session.lc_time_names=0/*!*/;SET @@session.collation_database=DEFAULT/*!*/;BEGIN/*!*/;# at 295#200423 16:45:11 server id 1end_log_pos 626 CRC32 0xa15900c0Querythread_id=4exec_time=0error_code=0use `chunyu`/*!*/;SET TIMESTAMP=1587631511/*!*/;UPDATE `article_article` SET `created_time` = '2020-04-23 08:17:20.953805', `last_modified` = '2020-04-23 08:45:11.324532', `user_id` = 1, `title` = '1', `content` = '999999', `status` = 1, `comment_count` = 0, `star_count` = 0 WHERE `article_article`.`id` = 2/*!*/;# at 626#200423 16:45:11 server id 1end_log_pos 657 CRC32 0xeb7a6863Xid = 14COMMIT/*!*/;SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/;DELIMITER ;# End of log file/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;推荐:《mysql视频教程》以上就是mac如何开启mysql bin-log的详细内容,更多请关注小潘博客其它相关文章!