MySQL启动时InnoDB报一些错误,这个怎么解决

发布网友发布时间：2022-05-07 14:04

共2个回答

懂视网时间：2022-05-07 18:25

bitsCN.com
更改innodb_log_file_size, 解决InnoDB: ERROR: the ag...的问题有时侯Mysql会报错: 120418 8:00:14 InnoDB: ERROR: the age of the last checkpoint is 9434204,InnoDB: which exceeds the log group capacity 9433498.InnoDB: If you are using big BLOB or TEXT rows, you must set theInnoDB: combined size of log files at least 10 times bigger than theInnoDB: largest such row 这主要是由于 innodb_log_file_size 默认是5M, 不够用引起的. 增大innodb_log_file_size的方法: 暂停mysql, /etc/init.d/mysql stop转移ib_logfile0和ib_logfile1, mv /usr/local/mysql/var/ib_logfile* ../编辑my.cnf , 增加 innodb_log_file_size=64M启动mysql, /etc/init.d/mysql start 作者 neou bitsCN.com

热心网友时间：2022-05-07 15:33

MySQL启动时InnoDB报一些错误，这个怎么解决

Sub s()
On Error Resume Next
Dim pth$, fn$, wb As Workbook