RDS 中的默认 mysql 参数是否正常?
RDS 对所有实例大小使用相同的参数集,并且它们似乎与默认值相差不远(max_packet_size 太小等)。
是否有人查看过它们并审查它们的合理性,尤其是在相对较大的实例上?
RDS uses the same set of parameters for all instance sizes and they don't seem to be that far from defaults (max_packet_size being too small etc.)
Has anyone looked at them and reviewed them for how sensible they are, especially on relatively bigger instances?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
RDS参数组中MyISAM的默认缓冲区大小太小,我对此进行了更改,显着提高了读/写性能。但是,请注意,RDS 并不支持所有 MySQL 参数,仅支持参数组中显示的参数。
The default buffer size for MyISAM is too small in RDS parameter group, I have made changes of that, make significant improvement in read/write performance. However, just beware, not all MySQL parameters are honored by RDS, only those ones shown in parameter group.
您可以随时更改参数集以适合您的应用。
you can always change the parameter set to fit your application.