mysql/mariadb很慢,报错:InnoDB: ERROR: the age of the last checkpoint is
问题
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
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
3、启动
systemctl start mariadb.service
参考:/news/upload/ueditor/image/202208/21c4osmaaxd
版权声明
本文仅代表作者观点,不代表博信信息网立场。