elelment 发表于 2023-2-1 17:55:43

【待反馈】mysql数据库无法启动

cmd和宝塔 都无法启动

错误日志为

盏尽 发表于 2023-2-1 18:26:13

您好，您打开数据库的配置文件，修改”innodb-log-buffer-size”把0.25M改一下，例如改成：4M或更大，再尝试启动MySQL
面板启动不了截图看一下错误日志

elelment 发表于 2023-2-1 18:34:03

堡塔运维盏尽 发表于 2023-2-1 18:26
您好，您打开数据库的配置文件，修改”innodb-log-buffer-size”把0.25M改一下，例如改成：4M或更大，再尝 ...

目前 没有找到这个参数

elelment 发表于 2023-2-1 18:37:24

找到了现在准备截图错误日志

elelment 发表于 2023-2-1 18:42:42

堡塔运维盏尽 发表于 2023-2-1 18:26
您好，您打开数据库的配置文件，修改”innodb-log-buffer-size”把0.25M改一下，例如改成：4M或更大，再尝 ...

'INNODB_METRICS'
2023-02-01T10:40:05.026998Z 0 Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2023-02-01T10:40:05.027309Z 0 Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-02-01T10:40:05.027546Z 0 Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-02-01T10:40:05.027786Z 0 Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-02-01T10:40:05.028001Z 0 Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-02-01T10:40:05.028272Z 0 Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-02-01T10:40:05.028540Z 0 Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-02-01T10:40:05.028760Z 0 Shutting down plugin 'INNODB_CMPMEM'
2023-02-01T10:40:05.028963Z 0 Shutting down plugin 'INNODB_CMP_RESET'
2023-02-01T10:40:05.029171Z 0 Shutting down plugin 'INNODB_CMP'
2023-02-01T10:40:05.029366Z 0 Shutting down plugin 'INNODB_LOCK_WAITS'
2023-02-01T10:40:05.029576Z 0 Shutting down plugin 'INNODB_LOCKS'
2023-02-01T10:40:05.029780Z 0 Shutting down plugin 'INNODB_TRX'
2023-02-01T10:40:05.029976Z 0 Shutting down plugin 'InnoDB'
2023-02-01T10:40:05.030228Z 0 InnoDB: FTS optimize thread exiting.
2023-02-01T10:40:05.030653Z 0 InnoDB: Starting shutdown...
2023-02-01T10:40:05.131592Z 0 InnoDB: Dumping buffer pool(s) to C:\BtSoft\mysql\MySQL5.7\data\ib_buffer_pool
2023-02-01T10:40:05.133370Z 0 InnoDB: Buffer pool(s) dump completed at 230201 18:40:05
2023-02-01T10:40:06.565770Z 0 InnoDB: Shutdown completed; log sequence number 2892142422
2023-02-01T10:40:06.566631Z 0 InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-02-01T10:40:06.566987Z 0 Shutting down plugin 'MEMORY'
2023-02-01T10:40:06.567211Z 0 Shutting down plugin 'CSV'
2023-02-01T10:40:06.567410Z 0 Shutting down plugin 'sha256_password'
2023-02-01T10:40:06.567671Z 0 Shutting down plugin 'mysql_native_password'
2023-02-01T10:40:06.568033Z 0 Shutting down plugin 'binlog'
2023-02-01T10:40:06.574192Z 0 C:\BtSoft\mysql\MySQL5.7\bin\mysqld.exe: Shutdown complete

盏尽 发表于 2023-2-2 08:50:42

elelment 发表于 2023-2-1 18:42
'INNODB_METRICS'
2023-02-01T10:40:05.026998Z 0 Shutting down plugin 'INNODB_ ...

这里没有明显的错误信息，您的MySQL现在是否能正常启动了呢？
页: [1]
查看完整版本: 【待反馈】mysql数据库无法启动