<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[chen_02_darling的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/chen_02_darling</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; chen_02_darling]]></copyright><item><title><![CDATA[网站服务器 MySQL 高 CPU 占用故障]]></title><link>https://blog.youkuaiyun.com/chen_02_darling/article/details/159502155</link><guid>https://blog.youkuaiyun.com/chen_02_darling/article/details/159502155</guid><author>chen_02_darling</author><pubDate>Tue, 07 Apr 2026 23:18:21 +0800</pubDate><description><![CDATA[摘要：Linux服务器上PHP+MySQL架构的网站突发CPU 100%占用问题，表现为页面加载卡顿。根因是WordPress元数据查询SQL中IN列表包含数百个ID且强制排序，导致MySQL无法使用索引而手动排序，引发CPU雪崩。故障触发点是Memcached缓存失效后热点SQL请求直接冲击数据库。临时解决方案包括终止慢查询、重启缓存服务；最终方案是改用Redis缓存并安装Redis插件。建议避免频繁修改SSL证书，防止缓存失效引发连锁反应。（149字）]]></description><category></category></item></channel></rss>