PURGE MASTER LOGS TO 'mybinlog.00003'; purge binary logs before '2021-07-13 19:11:00'; 还可以做减法:如只保留3天的 PURGE BINARY LOGS BEFORE now() - INTERVAL 3 day; 4)删除日期之前的日志:修改配置参数,让mysql自动执行 删除7天前的binlog #临时生效 SET GLOBAL expire_logs_days = 7; #永...
sysdate_is_now = 1innodb = FORCEinnodb_strict_mode = 1# BINARY LOGGING#log_bin= /var/lib/mysql/data/mysql-binexpire_logs_days = 7sync_binlog = 1## InnoDBinnodb-buffer-pool-size = 2Ginnodb-log-file-size = 128Minnodb-log-buffer-size = 4Minnodb-file-per-table = 1innodb_log_files_...
showbinarylogs; #查看binlog列表showmaster status; #查看最新的binlog mysql>showbinarylogs;+---+---+---+|Log_name|File_size|Encrypted|+---+---+---+|mysql-bin.000001|179|No||mysql-bin.000002|156|No|+---+---+---+2rowsinset(0.00sec) Binlog 文件是二进制文件,强行打开看到的必然是...
ERROR 1238 (HY000): Variable 'log_bin' is a read only variable 主要二进制配置参数设置后显示结果: log-bin=mysql-bin #开起命令log-bin= /var/lib/mysql/mysql-bin #二进制日志存放地点expire_logs_days=7#二进制日志更新日期binlog_cache_size=4mmax_binlog_cache_size=512mmax_binlog_size=100mbi...
expire_logs_days=7 slow_query_log=on slow_query_log_file=/data/mysql/my3306/logs/slow.log long_query_time=0.5 log_queries_not_using_indexes=1 skip-grant-tables [root@mysql2 ~]# mysqld & [root@mysql2 ~]# mysql mysql> flush privileges; ...
| Variable_name | Value | +---+---+ | expire_logs_days | 0 | +---+---+ 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 1.3、设置
expire_logs_days=3 #binlog每个日志文件大小 max_binlog_size=100m #binlog缓存大小 binlog_cache_size=10m max_binlog_cache_size=512m #发生事务时非事务语句的缓存的大小 binlog_stmt_cache_size=100m max_binlog_stmt_cache_size=100m 1. ...
#expire-logs-days=7 #independ dir /data/mysql_binlog log_bin=/data/mysql_binlog/binlog log_bin_index=/data/mysql_binlog/binlog.index binlog_expire_logs_seconds=604800 binlog_format = ROW log_timestamps = SYSTEM gtid-mode = ON ...
I’m running 5.7.19-17-log and I can’t set expire_log_days in the my.cnf. I’ve tried under [mysqld] and [mysqld-safe]. Is this a bug? error logfile message: 2017-12-06T17:38:26.486560Z 0 [ERROR] unknown variable ‘expire_log_days=5’ ...
# BINARY LOGGING # server_id = 1 log_bin = /mysql/binlog/mysql_bin expire_logs_days = 14 sync_binlog = 1 max_binlog_size = 100M /mysql/binlog/属于mysql:mysql 在重新启动mysql之 浏览0提问于2017-11-04得票数 0 2回答 突然间,大量的binlog文件 、、、 在Percona XtraDB集群的所有三个...