Shulou(Shulou.com)06/01 Report--

The following mainly brings you mac how to open the mysql bin-log method, I hope these words can bring you practical use, this is also the main purpose of my article on how to open the mysql bin-log method in mac. All right, don't talk too much nonsense, let's just read the following.

Add the following configuration

Expire_logs_days = 5 regularly clean log-bin = / usr/local/var/mysql/mysql_bin_log/mysql-bin # enable binlog, specify the file server_id = 1 # configuration mysql replication needs to be defined, cannot repeat binlog_format=MIXEDD with canal slaveId

Mysql.server restart / / restart mysql

Show variables like'% log_bin% to see if it is turned on

Show master status; View Log status

Flush logs; refreshes the log. After refreshing, a new Binlog log is created.

Reset master clears all log files in the directory

View the log file: mysqlbinlog-- base64-output=DECODE-ROWS-v mysql-bin.000001

/ *! 50530 SET @ @ SESSION.PSEUDONG SLAVESLAVEMODEP 1 / server id / 50003 SET @ OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;DELIMITER / *! * /; # at 4 2004 423 16:43:25 end_log_pos 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.Rollback Universe # at 123 / 200423 16:43:25 server id 1 end_log_pos 154 CRC32 0x21d20383 Previous-GTIDs# [empty] # 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=noSET @ @ SESSION.GTID_NEXT= 'ANONYMOUS / at 219 / 200423 16:45:11 server id 1 end_log_pos 295 CRC32 0xb8e6b396 Query thread_id=4 exec_time=0 error_code=0SET timestamp 1587631511 / SET @ @ session.foreign_key_checks=1, @ @ session.sql_auto_is_null=0, @ @ session.unique_checks=1, @ @ session.session.sqlharmmode1436549152, @ @ session.auto_increment_increment=1, @ @ session.autoincrement increment offsets1Universe utf8 * / *! / / SET @ @ session.session. Collationalization setting clientmakers 33cohort session. Collationalization connectionmakers 33coverages session. Collationalization serveration33pxxxxxxxxxxxxxxxx; SET timeset @ @ session.session .collationalization timestamps namespace namespaces; session .session .collationalization databaseholders default clientswords such as session.session .collationaldatabases database strings default codes, please at 295200423 16:45:11 server id 1 end_log_pos 626 CRC32 0xa15900c0 Query thread_id=4 exec_time=0 error_code=0use `chunyu` / *! *; SET timespacks 1587631511 UPDATE `last_ modified` = '2020-04-23 08 SET 1720.953805, `last_ modified` =' 2020-04-23 08 SET 4545 server id 11.324532, `user_ id` = 1, `title` = '1bike, `content` =' 99999999, `status` = 1, `statt` = 0, `statt` = 0 WHERE `article_ count` = 0 WHERE `article_ count`id` = 2 WHERE WHERE, server id 626, 200423 16:45:11 server id 1 end_log_pos 657 CRC32 0xeb7a6863 Xid SET @ @ SESSION.GTID_NEXT= 'AUTOMATIC' / * added by mysqlbinlog * / *! * /; DELIMITER; # End of log filewise / 50003 SET completed TYPEX / OLDMPLETIONTYPEN SET @ @ SESSION.PSEUDO_SLAVE_MODE=0*/

For the above about mac how to open the mysql bin-log method, you do not find it very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.