首页 / MYSQL / mysql/mariadb很慢，报错:InnoDB: ERROR: the age of the last checkpoint is

mysql/mariadb很慢，报错:InnoDB: ERROR: the age of the last checkpoint is

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql/mariadb很慢，报错:InnoDB: ERROR: the age of the last checkpoint is，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1555字，纯文字阅读大概需要3分钟。

内容图文

问题

mysql最新网络吞吐速度慢，到后台查看日志报错：

Version: '5.5.65-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
201023 14:19:01  InnoDB: ERROR: the age of the last checkpoint is 9444086,
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.
201023 14:19:36  InnoDB: ERROR: the age of the last checkpoint is 9444401,
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.
201023 14:20:01  InnoDB: ERROR: the age of the last checkpoint is 9444693,
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.
201023 14:20:21  InnoDB: ERROR: the age of the last checkpoint is 9444414,
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

优化方法

1、在[mysqld]节点添加：

innodb_log_buffer_size          = 32M
innodb_buffer_pool_size         = 3G
innodb_log_file_size            = 768M

2、停止服务

systemctl stop mariadb.service

2、删除日志

#切换到数据目录
cd /data/mysql 
rm -rf rm ib_logfile*

3、启动

systemctl start mariadb.service

 

内容总结

以上是互联网集市为您收集整理的mysql/mariadb很慢，报错:InnoDB: ERROR: the age of the last checkpoint is全部内容，希望文章能够帮你解决mysql/mariadb很慢，报错:InnoDB: ERROR: the age of the last checkpoint is所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/869831.html

来源：【匿名】