How does mac turn on the mysql bin-log method
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.
