InnoDB: ERROR: the age of the last checkpoint is
来源:互联网 发布:在天猫可以找淘宝店铺 编辑:程序博客网 时间:2024/05/16 17:39
160719 13:43:04 InnoDB: ERROR: the age of the last checkpoint is 9448350,
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: 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 默认是5M, 不够用引起的.
增大innodb_log_file_size的方法:
service mysqld stop
删除或转移ib_logfile0和ib_logfile1, rm -f /var/lib/mysql/ib_logfile*
编辑my.cnf , 增加 innodb_log_file_size=256M
启动mysql, service mysqld start
0 0
- InnoDB: ERROR: the age of the last checkpoint is
- MySQL##InnoDB: ERROR: the age of the last checkpoint is 9446699
- The golden age of the developer
- The golden age of the developer
- What is the TensorFlow checkpoint meta file?
- The Age Of Big Data Coming
- Retrieving the Last-Error Code
- The last day of October
- The last day of 5.1
- The last day of 2015
- [Bat] Error: The syntax of the command is incorrect.
- It is time now to proceed to the last part of the speculation
- Windows 10 is going to be the last major revision of the operating system.
- The last of the human freedoms
- The last of the Year 2009
- InnoDB: is in the future!
- error:control file or data file 1 is from before the last RESETLOGS
- The last Node of Link List
- android开发案例之使用JSON数据向服务器提交和获取服务器传递的Json数据
- 康托展开和逆康托展开
- 日期、泛型和集合与异常处理
- Mysql 多实例安装
- 数据库优化的方法简介
- InnoDB: ERROR: the age of the last checkpoint is
- 欢迎您在新浪博客安家
- Spring Boot教程 - 3. 将配置文件放到jar外部
- 【游记】还未泯灭的青春
- C语言中运算符优先级
- 前m大的数
- PAT B 1020. 月饼 (25)
- ES5中新增的Array方法详细说明
- PAT B 1021. 个位数统计 (15)