【待反馈】CUP负载这几天每天都突然间满几分钟.就出现慢...

为了能快速了解并处理您的问题，请提供以下基础信息：

面板、插件版本：永久授权 [size=1.2][url=] 9.2.0[/url]

系统版本：系统：CentOS 7

问题描述：CUP负载这几天每天都突然间满几分钟.就出现慢日志了 .连续几天了.也没看见大量恶意IP访问

相关截图（日志、错误）：慢日志  # Query_time: 17.892503  Lock_time: 0.000071 Rows_sent: 13  Rows_examined: 497989
SET timestamp=1728906388;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (3,50,51,52,53,54,55,56,57,58,59,60,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,598,599,600,601,602,603,604,370,394,395,396,397,398,399,400,401,402,403,404,405,406,407) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 258
# Query_time: 5.052051  Lock_time: 0.000080 Rows_sent: 6  Rows_examined: 200611
SET timestamp=1728906388;
SELECT id,userid,title,postdate,enddate,catid,areaid,thumb,description FROM xk_info WHERE is_check=1 and userid=＇486＇ ORDER BY postdate desc LIMIT 6;
# Time: 241014 19:46:29
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 184
# Query_time: 5.380899  Lock_time: 0.000081 Rows_sent: 6  Rows_examined: 200611
SET timestamp=1728906389;
SELECT id,userid,title,postdate,enddate,catid,areaid,thumb,description FROM xk_info WHERE is_check=1 and userid=＇486＇ ORDER BY postdate desc LIMIT 6;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 210
# Query_time: 20.099846  Lock_time: 0.000065 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906389;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (27,336,337,338,339,340,341,342,343,344,345,346,347,348) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 250
# Query_time: 5.232374  Lock_time: 0.000069 Rows_sent: 6  Rows_examined: 200611
SET timestamp=1728906389;
SELECT id,userid,title,postdate,enddate,catid,areaid,thumb,description FROM xk_info WHERE is_check=1 and userid=＇486＇ ORDER BY postdate desc LIMIT 6;
# Time: 241014 19:46:31
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 216
# Query_time: 18.712367  Lock_time: 0.000079 Rows_sent: 3  Rows_examined: 497989
SET timestamp=1728906391;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (9,192,193,194,195,196,197,198,199,200,201,202,446,447,448,449,450,451,452,453) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 244
# Query_time: 18.657484  Lock_time: 0.000063 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906391;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (27,336,337,338,339,340,341,342,343,344,345,346,347,348) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 202
# Query_time: 4.446715  Lock_time: 0.000043 Rows_sent: 6  Rows_examined: 169244
SET timestamp=1728906391;
SELECT * FROM xk_info WHERE  is_check=1 AND userid = ＇491＇ ORDER BY postdate DESC LIMIT 6;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 333
# Query_time: 3.501875  Lock_time: 0.000096 Rows_sent: 6  Rows_examined: 169244
SET timestamp=1728906391;
SELECT * FROM xk_info WHERE  is_check=1 AND userid = ＇491＇ ORDER BY postdate DESC LIMIT 6;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 241
# Query_time: 20.613288  Lock_time: 0.000063 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906391;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (27,336,337,338,339,340,341,342,343,344,345,346,347,348) order by postdate desc limit 25;
# Time: 241014 19:46:32
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 247
# Query_time: 14.319409  Lock_time: 0.000065 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (19,277,278,279,280,281,282,283,284,285,286,287,288,289,290) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 259
# Query_time: 15.097993  Lock_time: 0.000072 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (10,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,454,455,456,457,458,459) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 186
# Query_time: 13.281051  Lock_time: 0.000128 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (5,78,79,80,81,82,83,84,85,86,87,88,89,90,420,421,422,423,424,425,426,427) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 169
# Query_time: 13.869162  Lock_time: 0.000061 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (28,349,350,351,352,353,354,355,356,357,358,359,360) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 258
# Query_time: 3.109867  Lock_time: 0.000054 Rows_sent: 6  Rows_examined: 200611
SET timestamp=1728906392;
SELECT * FROM xk_info WHERE  is_check=1 AND userid = ＇486＇ ORDER BY postdate DESC LIMIT 6;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 192
# Query_time: 11.825734  Lock_time: 0.000099 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (28,349,350,351,352,353,354,355,356,357,358,359,360) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 251
# Query_time: 14.561302  Lock_time: 0.000101 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (19,277,278,279,280,281,282,283,284,285,286,287,288,289,290) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 191
# Query_time: 3.665968  Lock_time: 0.000052 Rows_sent: 6  Rows_examined: 200611
SET timestamp=1728906392;
SELECT * FROM xk_info WHERE  is_check=1 AND userid = ＇486＇ ORDER BY postdate DESC LIMIT 6;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 257
# Query_time: 20.289810  Lock_time: 0.000154 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where is_check=1  and catid in (580,581,582,583,584,585,586,587,588,589,590,591,592,593,594)  order by click desc, postdate desc LIMIT 0,8;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 184
# Query_time: 3.359239  Lock_time: 0.000052 Rows_sent: 6  Rows_examined: 200611
SET timestamp=1728906392;
SELECT * FROM xk_info WHERE  is_check=1 AND userid = ＇486＇ ORDER BY postdate DESC LIMIT 6;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 177
# Query_time: 16.049948  Lock_time: 0.000060 Rows_sent: 3  Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (9,192,193,194,195,196,197,198,199,200,201,202,446,447,448,449,450,451,452,453) order by postdate desc limit 25;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 223
# Query_time: 15.195108  Lock_time: 0.000062 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where is_check=1  and catid in (494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509) and areaid in (15)  order by click desc, postdate desc LIMIT 0,8;
# Time: 241014 19:46:33
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 200
# Query_time: 16.821937  Lock_time: 0.000065 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906393;
select * from xk_info where is_check=1  and catid in (580,581,582,583,584,585,586,587,588,589,590,591,592,593,594)  order by click desc, postdate desc LIMIT 0,8;
# User@Host: 99yecw_com[99yecw_com] @ localhost [127.0.0.1]  Id: 183
# Query_time: 12.413723  Lock_time: 0.000102 Rows_sent: 0  Rows_examined: 497989
SET timestamp=1728906393;
select * from xk_info where top_type=＇1＇ and is_check=1 and catid IN (5,78,79,80,81,82,83,84,85,86,87,88,89,90,420,421,422,423,424,425,426,427) order by postdate desc limit 25;

蓝易云 · 发表于 2024-10-15 01:33:01

Typecho博客？优化索引，Query_time 过长，Rows_examined 过多，LIMIT 查询未分页，排序和筛选未优化

A书记阿超 · 发表于 2024-10-15 17:33:09

不太懂这个，宝塔专业官方帮我看看，每次负载5分钟左右，没见什么恶意批量ip访问，。只查到网站日子异常日子那时间段每秒很多ip访问

堡塔运维南一 · 发表于 2024-11-5 15:37:41

A书记阿超发表于 2024-10-15 17:33
不太懂这个，宝塔专业官方帮我看看，每次负载5分钟左右，没见什么恶意批量ip访问，。只查到网站日子异常日 ...

您好，问题解决了吗，没有的话看一下私信，方便为您解决问题

█ 菠萝云-免费装宝塔,4G内存68 █	█ 易探云·香港/美国vps仅9元 █	▅▆▇ 慈云数据-服务器9.9/月 ▇▆▅	4C4G500M带宽高防69元	【多途云】高防CDN
高防服务器，无视一切流量攻击	A7招租，联系qq394030111	OV/EV SSL证书，可当日签发	【阿里云】宝塔一键部署，5.5折	宝塔一键部署DV,EV,OV,SSL证书
█ 易探云·高防云4核8G仅88元 █	高防CDN全球节点99元	█香港站群新年大促█ 免费试用 █	【阿里云】2核2G，3M，45.1元/年	在线网站测速、批量PING运维工具

【待反馈】CUP负载这几天每天都突然间 满几分钟.就出现慢...

【待反馈】CUP负载这几天每天都突然间满几分钟.就出现慢...