今天安装了mysql 8.0.31,启动mysql的时候一直报错
[ERROR] [MY-012962] [InnoDB] The redo log file ./#innodb_redo/#ib_redo5 size 2629632 is not a multiple of innodb_page_size
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
先是修改了数据存放目录,一样还是报错
然后在my.conf里配置了
innodb_log_file_size=16M
结果有了新的报错
[Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=33554432. Please use innodb_redo_log_capacity instead.
[System] [MY-013576] [InnoDB] InnoDB initialization has started.
[ERROR] [MY-012962] [InnoDB] The redo log file ./#innodb_redo/#ib_redo18 size 172032 is not a multiple of innodb_page_size
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
[ERROR] [MY-010020] [Server] Data Dic
意思就是 innodb_log_file_size 已经被废弃了,让使用新的参数 innodb_redo_log_capacity
于是就在my.conf里加上新的参数
innodb_redo_log_capacity = 16M
启动成功!!!!!!
原来最新版本 MySQL 8.0.30 发布后,使用新参数 innodb_redo_log_capacity 来代替之前的两个参数
mysql 启动失败
最新推荐文章于 2023-10-26 14:18:40 发布