mysql运行一会后所有表操作卡死，但是服务没挂

答案:2 悬赏:50 手机版

解决时间 2021-04-09 02:55

提问者网友：却不属于对方
2021-04-08 13:21

170623 12:00:23 InnoDB: Operating system error number 1450 in a file operation.
日志报错如下：秒级错误
InnoDB: The error means that there are no sufficient system resources or quota to complete the operation.
170623 12:00:23 InnoDB: Operating system error number 1450 in a file operation.
InnoDB: The error means that there are no sufficient system resources or quota to complete the operation.
170623 12:00:23 InnoDB: Operating system error number 1450 in a file operation.
InnoDB: The error means that there are no sufficient system resources or quota to complete the operation.
170623 12:00:23 InnoDB: Operating system error number 1450 in a file operation.
InnoDB: The error means that there are no sufficient system resources or quota to complete the operation.
170623 12:00:23 InnoDB: Operating system error number 1450 in a file operation.
InnoDB: The error means that there are no sufficient system resources or quota to complete the operation.
170623 12:00:23 InnoDB: Operating system error number 1450 in a file operation.
InnoDB: The error means that there are no sufficient system resources or quota to complete the operation.
170623 12:00:23 InnoDB: Operating system error number 1450 in a file operation.
InnoDB: The error means that there are no sufficient system resources or quota to complete the operation.
170623 12:00:23 InnoDB: Operating system error number 1450 in a file operation.
InnoDB: The error means that there are no sufficient system resources or quota to complete the operation.

最佳答案

五星知识达人网友：青灯有味
2021-04-08 14:01

mysql运行一会后所有表操作卡死，但是服务没挂
你执行下show variables like 'thread_concurrency';命令，查看系统当前thread_concurrency默认配置。

thread_concurrency应设为CPU核数的2倍. 比如有一个双核的CPU, 那thread_concurrency 的应该为4; 2个双核的cpu, thread_concurrency的值应为8.

全部回答

1楼网友：怀裏藏嬌
2021-04-08 15:08

没看懂什么意思？

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息