为什么在升级到 MySQL 8.x 后,包含多个 IN 值的查询成本更高?
原文英文,约2400词,阅读约需9分钟。发表于: 。Some of our Percona Support customers report performance degradation after a major MySQL upgrade, and there can be many different reasons for this. These days, the most common major upgrade is...
一些Percona Support的客户在升级MySQL后报告性能下降。最常见的升级是从MySQL 5.7升级到8.0。一个重要案例是范围优化问题,导致查询计划错误和内存需求不合理。已报告了相关回归和文档错误。在修复之前,建议考虑使用EOL支持。升级到MySQL 8.x需要充分测试以避免意外情况。