【待反馈】CUP负载这几天每天都突然间 满几分钟.就出现慢...
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本： 永久授权 9.2.0系统版本：系统：CentOS 7
问题描述：CUP负载这几天每天都突然间 满几分钟.就出现慢日志了 .连续几天了.也没看见大量恶意IP访问
相关截图（日志、错误）：慢日志# Query_time: 17.892503Lock_time: 0.000071 Rows_sent: 13Rows_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 @ localhost Id: 258
# Query_time: 5.052051Lock_time: 0.000080 Rows_sent: 6Rows_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 @ localhost Id: 184
# Query_time: 5.380899Lock_time: 0.000081 Rows_sent: 6Rows_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 @ localhost Id: 210
# Query_time: 20.099846Lock_time: 0.000065 Rows_sent: 0Rows_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 @ localhost Id: 250
# Query_time: 5.232374Lock_time: 0.000069 Rows_sent: 6Rows_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 @ localhost Id: 216
# Query_time: 18.712367Lock_time: 0.000079 Rows_sent: 3Rows_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 @ localhost Id: 244
# Query_time: 18.657484Lock_time: 0.000063 Rows_sent: 0Rows_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 @ localhost Id: 202
# Query_time: 4.446715Lock_time: 0.000043 Rows_sent: 6Rows_examined: 169244
SET timestamp=1728906391;
SELECT * FROM xk_info WHEREis_check=1 AND userid = ＇491＇ ORDER BY postdate DESC LIMIT 6;
# User@Host: 99yecw_com @ localhost Id: 333
# Query_time: 3.501875Lock_time: 0.000096 Rows_sent: 6Rows_examined: 169244
SET timestamp=1728906391;
SELECT * FROM xk_info WHEREis_check=1 AND userid = ＇491＇ ORDER BY postdate DESC LIMIT 6;
# User@Host: 99yecw_com @ localhost Id: 241
# Query_time: 20.613288Lock_time: 0.000063 Rows_sent: 0Rows_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 @ localhost Id: 247
# Query_time: 14.319409Lock_time: 0.000065 Rows_sent: 0Rows_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 @ localhost Id: 259
# Query_time: 15.097993Lock_time: 0.000072 Rows_sent: 0Rows_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 @ localhost Id: 186
# Query_time: 13.281051Lock_time: 0.000128 Rows_sent: 0Rows_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 @ localhost Id: 169
# Query_time: 13.869162Lock_time: 0.000061 Rows_sent: 0Rows_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 @ localhost Id: 258
# Query_time: 3.109867Lock_time: 0.000054 Rows_sent: 6Rows_examined: 200611
SET timestamp=1728906392;
SELECT * FROM xk_info WHEREis_check=1 AND userid = ＇486＇ ORDER BY postdate DESC LIMIT 6;
# User@Host: 99yecw_com @ localhost Id: 192
# Query_time: 11.825734Lock_time: 0.000099 Rows_sent: 0Rows_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 @ localhost Id: 251
# Query_time: 14.561302Lock_time: 0.000101 Rows_sent: 0Rows_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 @ localhost Id: 191
# Query_time: 3.665968Lock_time: 0.000052 Rows_sent: 6Rows_examined: 200611
SET timestamp=1728906392;
SELECT * FROM xk_info WHEREis_check=1 AND userid = ＇486＇ ORDER BY postdate DESC LIMIT 6;
# User@Host: 99yecw_com @ localhost Id: 257
# Query_time: 20.289810Lock_time: 0.000154 Rows_sent: 0Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where is_check=1and 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 @ localhost Id: 184
# Query_time: 3.359239Lock_time: 0.000052 Rows_sent: 6Rows_examined: 200611
SET timestamp=1728906392;
SELECT * FROM xk_info WHEREis_check=1 AND userid = ＇486＇ ORDER BY postdate DESC LIMIT 6;
# User@Host: 99yecw_com @ localhost Id: 177
# Query_time: 16.049948Lock_time: 0.000060 Rows_sent: 3Rows_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 @ localhost Id: 223
# Query_time: 15.195108Lock_time: 0.000062 Rows_sent: 0Rows_examined: 497989
SET timestamp=1728906392;
select * from xk_info where is_check=1and 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 @ localhost Id: 200
# Query_time: 16.821937Lock_time: 0.000065 Rows_sent: 0Rows_examined: 497989
SET timestamp=1728906393;
select * from xk_info where is_check=1and 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 @ localhost Id: 183
# Query_time: 12.413723Lock_time: 0.000102 Rows_sent: 0Rows_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;
Typecho博客？优化索引，Query_time 过长，Rows_examined 过多，LIMIT 查询未分页，排序和筛选未优化 不太懂这个，宝塔专业官方帮我看看，每次负载5分钟左右，没见什么恶意批量ip访问，。只查到网站日子异常日子那时间段每秒很多ip访问 A书记阿超 发表于 2024-10-15 17:33
不太懂这个，宝塔专业官方帮我看看，每次负载5分钟左右，没见什么恶意批量ip访问，。只查到网站日子异常日 ...
您好，问题解决了吗，没有的话看一下私信，方便为您解决问题
页:
[1]