https://blog.youkuaiyun.com/Lin_Willenzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/Lin_Willen/article/details/145695145https://blog.youkuaiyun.com/Lin_Willen/article/details/145695145Lin_WillenThu, 14 Aug 2025 00:05:18 +0800 20 的记录也被回表了，导致无效的磁盘 IO（回表需要读数据页）。 有索引下推时的优化：过滤逻辑 “下推” 到存储引擎 核心差异：把 age > 20 的过滤逻辑从服务器层 “下推” 到了存储引擎层，在索引层面就过滤掉无效记录，减少了回表次数 5、如何设计性]]>https://blog.youkuaiyun.com/Lin_Willen/article/details/114682834https://blog.youkuaiyun.com/Lin_Willen/article/details/114682834Lin_WillenTue, 08 Jul 2025 23:12:27 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/122524964https://blog.youkuaiyun.com/Lin_Willen/article/details/122524964Lin_WillenSun, 16 Jan 2022 20:26:24 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/122402176https://blog.youkuaiyun.com/Lin_Willen/article/details/122402176Lin_WillenMon, 10 Jan 2022 01:20:58 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/115279042https://blog.youkuaiyun.com/Lin_Willen/article/details/115279042Lin_WillenSun, 28 Mar 2021 17:25:03 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/114228216https://blog.youkuaiyun.com/Lin_Willen/article/details/114228216Lin_WillenSun, 28 Feb 2021 17:35:45 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/114224591https://blog.youkuaiyun.com/Lin_Willen/article/details/114224591Lin_WillenSun, 28 Feb 2021 15:30:45 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/113097923https://blog.youkuaiyun.com/Lin_Willen/article/details/113097923Lin_WillenSun, 24 Jan 2021 22:13:21 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/113091865https://blog.youkuaiyun.com/Lin_Willen/article/details/113091865Lin_WillenSun, 24 Jan 2021 16:38:29 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/113090563https://blog.youkuaiyun.com/Lin_Willen/article/details/113090563Lin_WillenSun, 24 Jan 2021 15:33:47 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/112602041https://blog.youkuaiyun.com/Lin_Willen/article/details/112602041Lin_WillenSun, 17 Jan 2021 13:26:52 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/112645721https://blog.youkuaiyun.com/Lin_Willen/article/details/112645721Lin_WillenFri, 15 Jan 2021 00:58:10 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/112503233https://blog.youkuaiyun.com/Lin_Willen/article/details/112503233Lin_WillenTue, 12 Jan 2021 00:47:21 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/112425937https://blog.youkuaiyun.com/Lin_Willen/article/details/112425937Lin_WillenSun, 10 Jan 2021 21:43:14 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/112423201https://blog.youkuaiyun.com/Lin_Willen/article/details/112423201Lin_WillenSun, 10 Jan 2021 11:30:59 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/112421078https://blog.youkuaiyun.com/Lin_Willen/article/details/112421078Lin_WillenSun, 10 Jan 2021 01:22:45 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/112395013https://blog.youkuaiyun.com/Lin_Willen/article/details/112395013Lin_WillenSat, 09 Jan 2021 18:05:49 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/112306351https://blog.youkuaiyun.com/Lin_Willen/article/details/112306351Lin_WillenThu, 07 Jan 2021 12:13:45 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/112255606https://blog.youkuaiyun.com/Lin_Willen/article/details/112255606Lin_WillenWed, 06 Jan 2021 00:56:46 +0800https://blog.youkuaiyun.com/Lin_Willen/article/details/112159318https://blog.youkuaiyun.com/Lin_Willen/article/details/112159318Lin_WillenTue, 05 Jan 2021 02:06:46 +0800