开发者

Intermittent MySQL error under high load: "Unknown MySQL server host 'XXXX'"

开发者 https://www.devze.com 2023-01-16 10:39 出处:网络
I have a MySQL server under heavy load (~960 queries per second) with ~ 400 clients continuously running queries against it. It is on a powerful machine (8 cores, Xeon, 3.3 GHz) and it looks like it c

I have a MySQL server under heavy load (~960 queries per second) with ~ 400 clients continuously running queries against it. It is on a powerful machine (8 cores, Xeon, 3.3 GHz) and it looks like it can keep up with the load, no problem.

Occasionally (once per week), all clie开发者_如何学Cnt processes will error at the same time with the message "Unknown MySQL server 'XXX'". Then, without me doing anything, they all come back to life a short time later.

I have max_connections set to 500, but I think that if I exceed that number then I should get a "Too many connections" error, and not the one I'm seeing.

Can anyone help me figure out why I'm getting these errors?

Thanks,

Jonathan

System specs:
8 cores, Xeon 3.2 GHz
Ubuntu 8.04
Kernel: Linux 2.6.24-27
MySQL 5.0.51a-3ubuntu5.7
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号