查看是否开启：
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 | 106 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin | ON |
+---------------+-------+
1 row in set (0.00 sec)
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 | 106 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin | ON |
+---------------+-------+
1 row in set (0.00 sec)
开启二进制日志
添加配置文件/etc/my.cnf log-bin参数
[root@JacTest01 binlogs]# more /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
log-bin=/var/lib/mysql/binlogs/mysql-bin
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
log-bin=/var/lib/mysql/binlogs/mysql-bin
修改权限
chown -R mysql:mysql /var/lib/mysql/binlogs
重新启动mysql服务
[root@JacTest01 binlogs]# service mysqld start
正在启动 mysqld： [确定]
正在启动 mysqld： [确定]
查看日志目录下内容
[root@JacTest01 mysqllog]# cd /var/lib/mysql/binlogs/
[root@JacTest01 binlogs]# ll
总用量 12
drwxr-xr-x. 2 mysql mysql 4096 5月 4 16:58 mysql-bin
-rw-rw----. 1 mysql mysql 106 5月 4 17:00 mysql-bin.000001
-rw-rw----. 1 mysql mysql 40 5月 4 17:00 mysql-bin.index
[root@JacTest01 binlogs]# ll
总用量 12
drwxr-xr-x. 2 mysql mysql 4096 5月 4 16:58 mysql-bin
-rw-rw----. 1 mysql mysql 106 5月 4 17:00 mysql-bin.000001
-rw-rw----. 1 mysql mysql 40 5月 4 17:00 mysql-bin.index
使用特殊工具mysqlbinlog工具查看日志日志内容
[root@JacTest01 binlogs]# mysqlbinlog mysql-bin.000001
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
删除全部日志：
mysql> reset master;
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
PURGE MASTER LOGS TO & PURGE MASTER LOGS BEFORE
执行PURGE MASTER LOGS TO 'mysql-bin.******'命令，是将'******'编号之前的所有日志进行删除
执行PURGE MASTER LOGS BEFORE 'yyyy-mm-dd hh:mm:ss'命令，是将在'yyyy-mm-dd hh:mm:ss'时间之前的所有日志进行删除
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28719055/viewspace-1622234/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
