Home >Database >Mysql Tutorial >清除mysqlbinarylog_MySQL
清除mysqlbinarylog_MySQL
- WBOYOriginal
- 2016-05-31 08:49:381182browse
bitsCN.com
作为一个oracle dba有时候不得不管理一下mysql数据库，当为主从库时需要阶段性清理mysql binary log，清楚方式如下：
首先查看mysql 的当前日志组
show master status;
确定当前日志组后删除日志文件
purge binary logs to 'mysql-bin.000795';
删除000795之前的日志
bitsCN.comStatement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：阿里巴巴数据库连接池--Druid_MySQLNext article：ERROR 1290 (HY000): The MySQL server is running with the --s_MySQL