有趣的优化
原文英文,约700词,阅读约需3分钟。发表于: 。Introduction # I recently encountered an intriguing bug. A user reported that their query was causing vtgate to fetch a large amount of data, sometimes resulting in an Out Of Memory (OOM) error....
这篇文章讲述了一个有趣的错误,用户报告查询导致vtgate获取大量数据,导致内存溢出错误。作者通过优化查询计划,将聚合操作下推到MySQL,提高了查询性能和资源利用率。这个优化展示了查询规划的复杂性和高效树重写在Vitess中的重要性。