【已完成】使用日志清理工具V2.3删除binlog后mysql无法启动
原因:只删了日志文件,没删索引,需同时处理mysql-bin.index2023-11-29T03:26:27.703022Z 0 'binlog_format' is deprecated and will be removed in a future release.
2023-11-29T03:26:27.703112Z 0 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-11-29T03:26:27.703232Z 0 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-29T03:26:27.703253Z 0 /www/server/mysql/bin/mysqld (mysqld 8.0.34) starting as process 32462
2023-11-29T03:26:27.933827Z 0 Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=4294967296. Please use innodb_redo_log_capacity instead.
2023-11-29T03:26:27.936088Z 1 InnoDB initialization has started.
2023-11-29T03:26:29.808664Z 1 InnoDB initialization has ended.
mysqld: File './mysql-bin.000028' not found (OS errno 2 - No such file or directory)
2023-11-29T03:26:29.974439Z 0 Could not open log file.
2023-11-29T03:26:29.974464Z 0 Can't init tc log
2023-11-29T03:26:29.974478Z 0 Aborting
2023-11-29T03:26:31.248261Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.34)Source distribution.
您好,当前日志清理工具并未有扫描到MySQL二进制日志的操作,您那边怎么操作的?我这里需要怎么复现?
这块看下是否有文件大小判断, 之前15G左右binlog的时候显示,现在我这里清过之后也没有了
页:
[1]