ITPub博客

首页 > 数字化转型 > ERP > Binary log管理

Binary log管理

原创 ERP 作者:mckobe23 时间:2009-04-13 13:48:22 0 删除 编辑

开启Binary log(二进制日志)记录Mysql更新内容,在服务重启或者超出binlog大小上限的情况下mysqld会创建新的binlog,时间长了本地会保留很多binlog,我们应将历史binlog清除


1.刷新日志

mysql > flush logs;

2.查看当然数据库binlog信息

mysql > show binary logs;

+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000023 | 149 |
| mysql-bin.000024 | 149 |
| mysql-bin.000025 | 149 |
| mysql-bin.000026 | 149 |
| mysql-bin.000027 | 149 |
| mysql-bin.000028 | 106 |
+------------------+-----------+


3.清除历史log,保留最近的

mysql > purge binary logs to 'mysql-bin.000028';


4.查看binlog事件

mysql > show binlog events;

+------------------+-----+-------------+-----------+-------------+---------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+------------------+-----+-------------+-----------+-------------+---------------------------------------+
| mysql-bin.000023 | 4 | Format_desc | 1 | 106 | Server ver: 5.1.31-log, Binlog ver: 4 |
| mysql-bin.000023 | 106 | Rotate | 1 | 149 | mysql-bin.000024;pos=4 |
+------------------+-----+-------------+-----------+-------------+---------------------------------------+


5.查看本地binlog文件

# ls -l /data/dbfile

mysql-bin.000028
mysql-bin.index

[@more@]

查看当前使用的Binary log名称

# more mysql-bin.index
./mysql-bin.000023
./mysql-bin.000024
./mysql-bin.000025
./mysql-bin.000026
./mysql-bin.000027
./mysql-bin.000028


备份中清除日志

# mysqldump --flush-logs --delete-master-logs

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9183234/viewspace-1020413/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-06-12

  • 博文量
    40
  • 访问量
    587271