nginx 不记录部分日志
通过linux管道加快oracle exp/imp的速度
2008/11/15 15:24 | by
发现mysql 的error log中的一段日志
查了一下是设置的innodb_log_file_size太小了，加大之后就好了，步骤如下
关闭mysql
修改my.cnf 将innodb_log_file_size从原来默认的5m改为100m
将mysql/data目录下的ib_logfile0，ib_logfile1这两个文件移走
启动mysql
引用
081103 15:05:44 InnoDB: ERROR: the age of the last checkpoint is 9433679,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
查了一下是设置的innodb_log_file_size太小了，加大之后就好了，步骤如下
关闭mysql
修改my.cnf 将innodb_log_file_size从原来默认的5m改为100m
将mysql/data目录下的ib_logfile0，ib_logfile1这两个文件移走
启动mysql
