<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Leron的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_44111464</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_44111464]]></copyright><item><title><![CDATA[Mysql加了索引查询速度变快但是使用EXPLANE分析仍然没走索引]]></title><link>https://blog.youkuaiyun.com/qq_44111464/article/details/124620716</link><guid>https://blog.youkuaiyun.com/qq_44111464/article/details/124620716</guid><author>qq_44111464</author><pubDate>Fri, 06 May 2022 23:20:19 +0800</pubDate><description><![CDATA[Mysql加了索引查询速度变快但是使用EXPLANE分析仍然没走索引
背景
最近在公司优化了一条sql，本来sql查询需要3秒左右，在某个列上加了索引之后速度变为了50毫秒左右，之后使用执行计划查看仍然没有走刚刚加的索引
案例SQL
SELECT
 某些字段
FROM
 表A AS a
 LEFT JOIN 表B as b ON a.rom_id = b.id 
WHERE a.room_id IN (
 SELECT
  f.id 
 FROM
  表D as d
  LEFT JOIN 表E as e ]]></description><category></category></item><item><title><![CDATA[MAC M1下Docker安装常用软件汇总]]></title><link>https://blog.youkuaiyun.com/qq_44111464/article/details/121931607</link><guid>https://blog.youkuaiyun.com/qq_44111464/article/details/121931607</guid><author>qq_44111464</author><pubDate>Tue, 14 Dec 2021 18:41:09 +0800</pubDate><description><![CDATA[M1下Docker安装软件汇总
1、Docker安装Nacos
下载支持M1版本的Nacos，这里以zhusaidong/nacos-server-m1:2.0.3为例
下载nacos
docker pull zhusaidong/nacos-server-m1:2.0.3

拷贝出Nacos容器内的配置文件并修改(如果不使用Mysql可以跳过)
docker container cp nacos:/home/nacos/conf .

需要修改的内容如下
# spring
......
# 使用Mysql]]></description><category></category></item></channel></rss>