<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[LUCKtou的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/LUCKtou</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; LUCKtou]]></copyright><item><title><![CDATA[如何在MySQL中跟踪存储过程的执行情况]]></title><link>https://blog.youkuaiyun.com/LUCKtou/article/details/122809776</link><guid>https://blog.youkuaiyun.com/LUCKtou/article/details/122809776</guid><author>LUCKtou</author><pubDate>Mon, 07 Feb 2022 15:44:08 +0800</pubDate><description><![CDATA[通过performance_schema中的events_statements_current和events_statements_history表信息跟踪存MySQL储过程执行情况]]></description><category></category></item><item><title><![CDATA[检查并删除mysql中多余的索引]]></title><link>https://blog.youkuaiyun.com/LUCKtou/article/details/118702224</link><guid>https://blog.youkuaiyun.com/LUCKtou/article/details/118702224</guid><author>LUCKtou</author><pubDate>Tue, 13 Jul 2021 16:34:48 +0800</pubDate><description><![CDATA[接手了一个无人管理的mysql数据库，发现有的表建了巨量索引（单表40个索引）；

需要对整个数据库做一个索引使用情况的检测，并按照需求删除不用的索引，写了下面的sql用于排查和生成drop index的sql；

注：mysql版本5.7.31


SELECT
	TAB.TABLE_SCHEMA,
	TAB.TABLE_NAME,
	IND.INDEX_NAME,
    TAB.INDEX_TYPE,
	TAB.NUM AS INDEX_NUM, #单表中索引总数
	IND.COUNT_STAR AS]]></description><category></category></item></channel></rss>