<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[pengming97的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/pengming97</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; pengming97]]></copyright><item><title><![CDATA[SpringBoot 集成 Flowable工作流]]></title><link>https://blog.youkuaiyun.com/pengming97/article/details/127027694</link><guid>https://blog.youkuaiyun.com/pengming97/article/details/127027694</guid><author>pengming97</author><pubDate>Sat, 24 Sep 2022 17:07:00 +0800</pubDate><description><![CDATA[SpringBoot 集成 Flowable工作流]]></description><category></category></item><item><title><![CDATA[app支付宝验证登录]]></title><link>https://blog.youkuaiyun.com/pengming97/article/details/127027203</link><guid>https://blog.youkuaiyun.com/pengming97/article/details/127027203</guid><author>pengming97</author><pubDate>Sat, 24 Sep 2022 16:36:53 +0800</pubDate><description><![CDATA[支付宝登录]]></description><category></category></item><item><title><![CDATA[Thread.sleep(0)是真的有用]]></title><link>https://blog.youkuaiyun.com/pengming97/article/details/126971845</link><guid>https://blog.youkuaiyun.com/pengming97/article/details/126971845</guid><author>pengming97</author><pubDate>Wed, 21 Sep 2022 14:20:23 +0800</pubDate><description><![CDATA[Thread.Sleep(0)的妙用]]></description><category></category></item><item><title><![CDATA[Mysql数据库SQL慢查询，除了索引，还能因为什么？]]></title><link>https://blog.youkuaiyun.com/pengming97/article/details/124384170</link><guid>https://blog.youkuaiyun.com/pengming97/article/details/124384170</guid><author>pengming97</author><pubDate>Sun, 24 Apr 2022 15:41:20 +0800</pubDate><description><![CDATA[mysql查询为什么会慢，关于这个问题，在实际开发经常会遇到，而面试中，也是个高频题。

遇到这种问题，我们一般也会想到是因为索引。

那除开索引之外，还有哪些因素会导致数据库查询变慢呢？

有哪些操作，可以提升mysql的查询能力呢？

今天就来聊聊会导致数据库查询变慢的场景有哪些，并给出原因和解决方案。



数据库查询流程

我们先来看下，一条查询语句下来，会经历哪些流程。

比如我们有一张数据库表


CREATETABLE`user`(
`id`int(10)unsignedNOT...]]></description><category></category></item><item><title><![CDATA[RabbitMQ的安装和使用]]></title><link>https://blog.youkuaiyun.com/pengming97/article/details/124322303</link><guid>https://blog.youkuaiyun.com/pengming97/article/details/124322303</guid><author>pengming97</author><pubDate>Thu, 21 Apr 2022 15:12:10 +0800</pubDate><description><![CDATA[在win环境中安装RabbitMQ]]></description><category></category></item><item><title><![CDATA[MQ延迟队列实现延迟消息]]></title><link>https://blog.youkuaiyun.com/pengming97/article/details/124299408</link><guid>https://blog.youkuaiyun.com/pengming97/article/details/124299408</guid><author>pengming97</author><pubDate>Wed, 20 Apr 2022 15:50:46 +0800</pubDate><description><![CDATA[MQ延迟队列实现延迟消息]]></description><category></category></item><item><title><![CDATA[Rabbit延时队列实现延迟消息-超时订单关闭]]></title><link>https://blog.youkuaiyun.com/pengming97/article/details/124298860</link><guid>https://blog.youkuaiyun.com/pengming97/article/details/124298860</guid><author>pengming97</author><pubDate>Wed, 20 Apr 2022 15:35:03 +0800</pubDate><description><![CDATA[消息队列实现延迟消息]]></description><category></category></item></channel></rss>