Mysql开启binlog日志

最新推荐文章于 2024-07-04 19:00:00 发布

hbhe0316

最新推荐文章于 2024-07-04 19:00:00 发布

阅读量173

点赞数

文章标签： mysql python java linux log4j2

本文链接：https://blog.csdn.net/hbhe0316/article/details/122701127

版权

本文详细介绍了如何检查与开启MySQL的binlog日志功能。首先通过`show variables like 'log_bin%'`确认binlog初始状态为关闭，然后编辑`/etc/my.cnf`文件，添加配置启用binlog，并设置相关参数。接着重启MySQL服务，再次检查发现binlog已开启。最后，验证/binlogs目录下已生成binlog日志文件。

摘要由CSDN通过智能技术生成

1.查看是否开启binlog日志

https://www.cndba.cn/hbhe0316/article/22610

mysql> show variables like 'log_bin%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin                         | OFF   |
| log_bin_basename                |       |
| log_bin_index                   |       |
| log_bin_trust_function_creators | OFF   |
| log_bin_use_v1_row_events       | OFF   |
+---------------------------------+-------+
5 rows in set (0.00 sec)

2.编辑/etc/my.cnf文件https://www.cndba.cn/hbhe0316/article/22610

log-bin=/logs/mysql-bin
binlog_format=mixed
server-id = 1
expire_logs_days=10

3.重启Mysql

[root@mysql57 ~]# service mysqld restart
Shutting down MySQL.. SUCCESS! 
Starting MySQL.. SUCCESS!

4.再次查看binlog是否开启

https://www.cndba.cn/hbhe0316/article/22610

mysql> show variables like 'log_bin%';
+---------------------------------+-----------------------+
| Variable_name                   | Value                 |
+---------------------------------+-----------------------+
| log_bin                         | ON                    |
| log_bin_basename                | /logs/mysql-bin       |
| log_bin_index                   | /logs/mysql-bin.index |
| log_bin_trust_function_creators | OFF                   |
| log_bin_use_v1_row_events       | OFF                   |
+---------------------------------+-----------------------+
5 rows in set (0.00 sec)

5.查看/logs下是否有binlog日志生成https://www.cndba.cn/hbhe0316/article/22610https://www.cndba.cn/hbhe0316/article/22610

[root@mysql57 logs]# ll
total 136
-rw-r--r-- 1 mysql mysql 115640 Nov 27 08:10 mysql57.log
-rw-r----- 1 mysql mysql    154 Nov 27 08:10 mysql-bin.000001
-rw-r----- 1 mysql mysql     23 Nov 27 08:10 mysql-bin.index

MYSQL

hbhe0316

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Mysql开启binlog日志

1.查看是否开启binlog日志 https://www.cndba.cn/hbhe0316/article/22610 https://www.cndba.cn/hbhe0316/article/22610 mysql> show variables like 'log_bin%';+---------------------------------+---...
复制链接

扫一扫