mysql 二进制日志

查看是否开启：

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)

开启二进制日志

添加配置文件/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

修改权限

chown -R mysql:mysql /var/lib/mysql/binlogs

重新启动mysql服务

[root@JacTest01 binlogs]# service mysqld start

正在启动 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

使用特殊工具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

删除全部日志：

mysql> reset master;

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'时间之前的所有日志进行删