1.功能说明
解决部分MySQL服务无法正常启动问题
2.操作说明
2.1问题说明
软件安装向导界面创建数据库文件时，MySQL服务无法启动导致无法进行下一步
- mysql错误日志体现：
2023-10-19T09:53:28.071961Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-10-19T09:53:28.072087Z 0 [Warning] '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-10-19T09:53:28.072110Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-10-19T09:53:28.072589Z 0 [Note] E:CMSServerV6mysqlingpsmysqld (mysqld 5.7.28) starting as process 11900 ...
2023-10-19T09:53:28.074301Z 0 [ERROR] Error message file 'E:CMSServerV6mysqlshareenglisherrmsg.sys' had only 1114 error messages,
but it should contain at least 1119 error messages.
Check that the above file is the right version for this program!
2023-10-19T09:53:28.080970Z 0 [Warning] You need to use --log-bin to make --binlog-format work.
2023-10-19T09:53:28.106794Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-10-19T09:53:28.107323Z 0 [Note] InnoDB: Uses event mutexes
2023-10-19T09:53:28.107640Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2023-10-19T09:53:28.108052Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-10-19T09:53:28.109001Z 0 [Note] InnoDB: Number of pools: 1
2023-10-19T09:53:28.109556Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2023-10-19T09:53:28.112795Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-10-19T09:53:28.120309Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-19T09:53:28.138613Z 0 [Note] InnoDB: Setting log file .ib_logfile101 size to 48 MB
2023-10-19T09:53:28.195609Z 0 [Note] InnoDB: Setting log file .ib_logfile1 size to 48 MB
2023-10-19T09:53:28.313921Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.
2023-10-19T09:53:28.314362Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2023-10-19T09:53:28.315019Z 0 [ERROR] InnoDB: File .ib_logfile101: 'aio write' returned OS error 187. Cannot continue operation
2023-10-19T09:53:28.315522Z 0 [ERROR] InnoDB: Cannot continue operation.
2.2处理方法：
编辑my.ini配置文件，[mysqld]下添加以下配置项，保存后重新执行软件安装向导，即可正常启动。
innodb_flush_method = normal