mysql 导入sql数据时报错

InnoDB: page_cleaner: 1000ms intended loop took ????ms. The settings might 。。。。。

 

在配置文件中添加:

[mysqld]
innodb_buffer_pool_instances=8 innodb_io_capacity_max = 40000 innodb_io_capacity = 20000 innodb_buffer_pool_size = 125G innodb_page_cleaners=8
innodb_page_cleaners和
innodb_buffer_pool_instances
尽量一致。

mysql 导入sql数据时报错

上一篇:Docker 镜像push上传远程仓库出错:requested access to the resource is denied


下一篇:命令行中执行批量SQL的方法