cannot retrieve MAC address，mac mysql log在哪里_mac如何開啟mysql bin-log

2023-10-04 阅读 24 评论 0

摘要：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重復cannot retrieve MAC ad

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重復

cannot retrieve MAC address？binlog_format=MIXEDD

mysql.server restart // 重啟mysql

show variables like '%log_bin% 查看是否開啟

show master status;查看日志狀態

Mysql命令，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*/;

mysql如何開啟binlog、DELIMITER /*!*/;

# at 4

#200423 16:43:25 server id 1 end_log_pos 123 CRC32 0xb303c132 Start: 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.

cmd登錄mysql數據庫。ROLLBACK/*!*/;

# at 123

#200423 16:43:25 server id 1 end_log_pos 154 CRC32 0x21d20383 Previous-GTIDs

# [empty]

MySQL數據庫啟動命令？# at 154

#200423 16:45:11 server id 1 end_log_pos 219 CRC32 0xfb334efd Anonymous_GTID last_committed=0 sequence_number=1 rbr_only=no

SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;

# at 219

mysql關閉binlog日志、#200423 16:45:11 server id 1 end_log_pos 295 CRC32 0xb8e6b396 Query thread_id=4 exec_time=0 error_code=0

SET 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 1 end_log_pos 626 CRC32 0xa15900c0 Query thread_id=4 exec_time=0 error_code=0

use `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 1 end_log_pos 657 CRC32 0xeb7a6863 Xid = 14

COMMIT/*!*/;

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*/;