为什么 MySQL 在设计上会在超过 max_packet_size 时关闭连接?基于证据的意见可以作为答案
我有许多 WordPress 网站由于请求超出了 max_packet_size 而随机崩溃。
我刚刚增加了大小,希望将来避免这种情况,但我不明白为什么 MySQL 会故意对太大的请求严格连接而不是拒绝它。
这会导致这些网站瘫痪。而且我不相信增加 max_packet_size 真的可以解决根本问题,即关闭。
https://dev.mysql.com/doc/ refman/8.0/en/packet-too-large.html
有谁知道为什么会发生这种情况?我对这个问题的看法是否缺乏?
I have numerous WordPress websites that crash at random due to max_packet_size being exceeded by a request.
I have just increased the size, to hopefully avoid this in the future, but I don't understand why MySQL would intentionally severe a connection for a request that was too large instead of rejecting it.
This results in these websites going down. And I'm not confident that increasing the max_packet_size really solves the root problem which is the shutting down.
https://dev.mysql.com/doc/refman/8.0/en/packet-too-large.html
Does anyone have any insight as to why this occurs? Is my perspective on this issue lacking?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论