網站經常504

huyuzhe

1.服務器資源沒問題
2.解析沒問題
3.CDN沒問題

（我在模板主頁index里加入了遮罩代碼和iframe嵌套代碼，遮罩上引入了CSS文件，有背景視頻4M多，有一個logo和導航菜單，這個是否影響？）
php和nginx都按照網絡教程配置過。
過一會網站就正常了，真是摸不到頭腦了。

網站主頁經常504 Gateway Time-out ，但是網站子目錄的index.html能正常訪問，是什么問題？
網站主頁：www.huyuzhe.com
子目錄：https://www.huyuzhe.com/yxmsvip/JuHeSouSuo/index.html

我知道答案 回答被采納將會獲得1 貢獻 已有16人回答

huyuzhe

false001

有背景視頻4M多

去掉它先看看？或者有沒有更詳細的php慢日志呢？

huyuzhe

false001 發表于 2024-3-4 22:11
去掉它先看看？或者有沒有更詳細的php慢日志呢？

PHP慢日志：

www/wwwroot/www.huyuzhe.com/source/class/discuz/discuz_database.php:48
[0x00007f2aaf0148c0] delete() /www/wwwroot/www.huyuzhe.com/source/plugin/k_spider/spider.class.php:75
[0x00007f2aaf014720] k_spider() /www/wwwroot/www.huyuzhe.com/source/plugin/k_spider/spider.class.php:81
[0x00007f2aaf0146a0] global_footer() /www/wwwroot/www.huyuzhe.com/source/function/function_core.php:1319
[0x00007f2aaf0144c0] hookscript() /www/wwwroot/www.huyuzhe.com/source/function/function_core.php:1359
[0x00007f2aaf014420] hookscriptoutput() /www/wwwroot/www.huyuzhe.com/data/template/2_diy_forum_forumdisplay.tpl.php:1
[0x00007f2aaf013d60] [INCLUDE_OR_EVAL]() /www/wwwroot/www.huyuzhe.com/source/module/forum/forum_forumdisplay.php:983
[0x00007f2aaf013100] [INCLUDE_OR_EVAL]() /www/wwwroot/www.huyuzhe.com/forum.php:71

[04-Mar-2024 22:02:49]  [pool www] pid 18082
script_filename = /www/wwwroot/www.huyuzhe.com/forum.php
[0x00007f2aaf0147f0] query() /www/wwwroot/www.huyuzhe.com/source/class/db/db_driver_mysqli.php:141
[0x00007f2aaf014710] query() /www/wwwroot/www.huyuzhe.com/source/class/discuz/discuz_database.php:142
[0x00007f2aaf014650] query() /www/wwwroot/www.huyuzhe.com/source/class/discuz/discuz_database.php:48
[0x00007f2aaf014550] delete() /www/wwwroot/www.huyuzhe.com/source/plugin/k_spider/spider.class.php:75
[0x00007f2aaf0143b0] k_spider() /www/wwwroot/www.huyuzhe.com/source/plugin/k_spider/spider.class.php:81
[0x00007f2aaf014330] global_footer() /www/wwwroot/www.huyuzhe.com/source/function/function_core.php:1319
[0x00007f2aaf014150] hookscript() /www/wwwroot/www.huyuzhe.com/source/function/function_core.php:1359
[0x00007f2aaf0140b0] hookscriptoutput() /www/wwwroot/www.huyuzhe.com/data/template/4_diy_touch_forum_forumdisplay.tpl.php:1
[0x00007f2aaf013d60] [INCLUDE_OR_EVAL]() /www/wwwroot/www.huyuzhe.com/source/module/forum/forum_forumdisplay.php:983
[0x00007f2aaf013100] [INCLUDE_OR_EVAL]() /www/wwwroot/www.huyuzhe.com/forum.php:71

huyuzhe

堡塔我開了防爆破

false001

k_spider

這是一個什么插件？能停掉嗎？

huyuzhe

false001 發表于 2024-3-5 10:33
這是一個什么插件？能停掉嗎？

huyuzhe

huyuzhe 發表于 2024-3-5 13:59

這個有問題嗎？

科站網

看mysql慢日志

huyuzhe

mysql慢日志 ：


SET timestamp=1709579063;
DELETE FROM pre_k_spider WHERE spider_time ＜ ＇1706987051＇;
# Time: 2024-03-04T19:04:38.623324Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 14274
# Query_time: 36.536060  Lock_time: 29.201423 Rows_sent: 0  Rows_examined: 506615
SET timestamp=1709579078;
DELETE FROM pre_k_spider WHERE spider_time ＜ ＇1706987041＇;
# Time: 2024-03-04T19:04:38.631825Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 14326
# Query_time: 6.842157  Lock_time: 0.000065 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709579078;
REPLACE INTO pre_common_cache SET `cachekey`=＇threadclasscount_87＇ , `cachevalue`=＇a:2:{s:6:\＂sortid\＂;a:25:{i:5;s:1:\＂0\＂;i:74;s:1:\＂0\＂;i:1;s:1:\＂0\＂;i:59;s:1:\＂0\＂;i:61;s:1:\＂0\＂;i:3;s:1:\＂0\＂;i:69;s:1:\＂0\＂;i:6;s:1:\＂0\＂;i:15;s:1:\＂0\＂;i:60;s:1:\＂0\＂;i:4;s:1:\＂0\＂;i:11;s:1:\＂0\＂;i:7;s:1:\＂0\＂;i:8;s:1:\＂0\＂;i:58;s:1:\＂0\＂;i:27;s:1:\＂0\＂;i:56;s:1:\＂0\＂;i:12;s:1:\＂0\＂;i:9;s:1:\＂0\＂;i:10;s:1:\＂0\＂;i:28;s:1:\＂0\＂;i:73;s:1:\＂0\＂;i:87;s:1:\＂0\＂;i:52;s:1:\＂0\＂;i:62;s:1:\＂0\＂;}s:6:\＂typeid\＂;a:2:{i:622;s:1:\＂0\＂;i:667;s:1:\＂0\＂;}}＇;
# Time: 2024-03-04T19:06:31.957988Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 14457
# Query_time: 49.090919  Lock_time: 45.694871 Rows_sent: 0  Rows_examined: 506803
SET timestamp=1709579191;
DELETE FROM pre_k_spider WHERE spider_time ＜ ＇1706987142＇;
# Time: 2024-03-04T19:15:38.907112Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 14930
# Query_time: 21.420862  Lock_time: 0.000053 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709579738;
DELETE FROM pre_common_process WHERE processid=＇DZ_CRON_27＇ OR expiry＜1709579717;
# Time: 2024-03-04T20:01:20.621849Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 17800
# Query_time: 4.017291  Lock_time: 0.000084 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709582480;
REPLACE INTO pre_common_cache SET `cachekey`=＇threadclasscount_130＇ , `cachevalue`=＇a:2:{s:6:\＂sortid\＂;a:5:{i:5;s:1:\＂0\＂;i:7;s:1:\＂0\＂;i:103;s:1:\＂0\＂;i:127;s:1:\＂0\＂;i:90;s:1:\＂0\＂;}s:6:\＂typeid\＂;a:2:{i:586;s:1:\＂0\＂;i:685;s:1:\＂0\＂;}}＇;
# Time: 2024-03-04T21:01:44.324211Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 18892
# Query_time: 10.667173  Lock_time: 0.000098 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709586104;
REPLACE INTO pre_common_cache SET `cachekey`=＇threadclasscount_130＇ , `cachevalue`=＇a:2:{s:6:\＂sortid\＂;a:5:{i:5;s:1:\＂0\＂;i:7;s:1:\＂0\＂;i:103;s:1:\＂0\＂;i:127;s:1:\＂0\＂;i:90;s:1:\＂0\＂;}s:6:\＂typeid\＂;a:2:{i:586;s:1:\＂0\＂;i:685;s:1:\＂0\＂;}}＇;
# Time: 2024-03-04T21:01:44.324368Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 18894
# Query_time: 3.121358  Lock_time: 0.000099 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709586104;
INSERT INTO pre_k_spider SET `spider`=＇Google＇ , `spider_time`=＇1709586100＇ , `spider_url`=＇https://www.huyuzhe.com/forum.php?mod=forumdisplay&fid=87&filter=sortid&sortid=5&searchsort=1&hyfl=3&zpfl=13&jy=3&dq_5=30&xb=1&dateline=86400＇ , `url_title`=＇分類信息-呼吁者＇ , `spider_ip`=＇115.220.11.98＇ , `agent`=＇mozilla/5.0 (linux; android 6.0.1; nexus 5x build/mmb29p) applewebkit/537.36 (khtml, like gecko) chrome/121.0.6167.139 mobile safari/537.36 (compatible; googlebot/2.1; +http://www.google.com/bot.html)＇ , `sfrom`=＇mobile＇;
# Time: 2024-03-04T21:02:26.472879Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 18907
# Query_time: 3.770580  Lock_time: 0.000078 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709586146;
REPLACE INTO pre_common_cache SET `cachekey`=＇threadclasscount_130＇ , `cachevalue`=＇a:2:{s:6:\＂sortid\＂;a:5:{i:5;s:1:\＂0\＂;i:7;s:1:\＂0\＂;i:103;s:1:\＂0\＂;i:127;s:1:\＂0\＂;i:90;s:1:\＂0\＂;}s:6:\＂typeid\＂;a:2:{i:586;s:1:\＂0\＂;i:685;s:1:\＂0\＂;}}＇;
# Time: 2024-03-05T01:01:30.184863Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 28762
# Query_time: 4.827048  Lock_time: 0.000101 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709600490;
INSERT INTO pre_k_spider SET `spider`=＇Google＇ , `spider_time`=＇1709600484＇ , `spider_url`=＇https://www.huyuzhe.com/forum.php?mod=forumdisplay&fid=87&filter=sortid&sortid=5&searchsort=1&dq_5=23&zpfl=6&hyfl=27&jy=1&xb=1&dateline=86400＇ , `url_title`=＇分類信息-呼吁者＇ , `spider_ip`=＇115.220.11.14＇ , `agent`=＇mozilla/5.0 (linux; android 6.0.1; nexus 5x build/mmb29p) applewebkit/537.36 (khtml, like gecko) chrome/121.0.6167.139 mobile safari/537.36 (compatible; googlebot/2.1; +http://www.google.com/bot.html)＇ , `sfrom`=＇mobile＇;
# Time: 2024-03-05T01:02:22.289494Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 28796
# Query_time: 3.951098  Lock_time: 0.000076 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709600542;
REPLACE INTO pre_common_cache SET `cachekey`=＇threadclasscount_130＇ , `cachevalue`=＇a:2:{s:6:\＂sortid\＂;a:5:{i:5;s:1:\＂0\＂;i:7;s:1:\＂0\＂;i:103;s:1:\＂0\＂;i:127;s:1:\＂0\＂;i:90;s:1:\＂0\＂;}s:6:\＂typeid\＂;a:2:{i:586;s:1:\＂0\＂;i:685;s:1:\＂0\＂;}}＇;
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                 Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                 Id Command    Argument
# Time: 2024-03-05T04:05:38.690401Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id:  8398
# Query_time: 3.073701  Lock_time: 0.000056 Rows_sent: 0  Rows_examined: 0
use www_huyuzhe_com;
SET timestamp=1709611538;
REPLACE INTO pre_common_cache SET `cachekey`=＇threadclasscount_135＇ , `cachevalue`=＇a:1:{s:6:\＂sortid\＂;a:1:{i:1;s:1:\＂0\＂;}}＇;
# Time: 2024-03-05T05:01:59.672035Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id:  9356
# Query_time: 9.904640  Lock_time: 0.000127 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709614919;
SELECT id from pre_common_banned WHERE expiration ＞ 1709614909 AND lowerip ＜= 0x00000000000000000000000034a790b9 AND upperip ＞= 0x00000000000000000000000034a790b9;
# Time: 2024-03-05T05:03:41.489625Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id:  9380
# Query_time: 3.085228  Lock_time: 0.000084 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709615021;
REPLACE INTO pre_common_cache SET `cachekey`=＇threadclasscount_130＇ , `cachevalue`=＇a:2:{s:6:\＂sortid\＂;a:5:{i:5;s:1:\＂0\＂;i:7;s:1:\＂0\＂;i:103;s:1:\＂0\＂;i:127;s:1:\＂0\＂;i:90;s:1:\＂0\＂;}s:6:\＂typeid\＂;a:2:{i:586;s:1:\＂0\＂;i:685;s:1:\＂0\＂;}}＇;
# Time: 2024-03-05T05:17:10.431267Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id:  9603
# Query_time: 9.124723  Lock_time: 0.000079 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709615830;
REPLACE INTO pre_common_cache SET `cachekey`=＇threadclasscount_130＇ , `cachevalue`=＇a:2:{s:6:\＂sortid\＂;a:5:{i:5;s:1:\＂0\＂;i:7;s:1:\＂0\＂;i:103;s:1:\＂0\＂;i:127;s:1:\＂0\＂;i:90;s:1:\＂0\＂;}s:6:\＂typeid\＂;a:2:{i:586;s:1:\＂0\＂;i:685;s:1:\＂0\＂;}}＇;
# Time: 2024-03-05T05:17:10.433833Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id:  9605
# Query_time: 6.599067  Lock_time: 0.000097 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709615830;
INSERT INTO pre_k_spider SET `spider`=＇Google＇ , `spider_time`=＇1709615822＇ , `spider_url`=＇https://www.huyuzhe.com/forum.php?mod=forumdisplay&fid=87&filter=sortid&sortid=5&searchsort=1&zpfl=19&jy=4&hyfl=10.4&dq_5=8&xb=1&dateline=86400＇ , `url_title`=＇分類信息-呼吁者＇ , `spider_ip`=＇115.220.11.95＇ , `agent`=＇mozilla/5.0 (linux; android 6.0.1; nexus 5x build/mmb29p) applewebkit/537.36 (khtml, like gecko) chrome/121.0.6167.139 mobile safari/537.36 (compatible; googlebot/2.1; +http://www.google.com/bot.html)＇ , `sfrom`=＇mobile＇;
# Time: 2024-03-05T06:02:06.853971Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 10399
# Query_time: 12.595231  Lock_time: 0.000124 Rows_sent: 0  Rows_examined: 511196
SET timestamp=1709618526;
DELETE FROM pre_k_spider WHERE spider_time ＜ ＇1708322514＇;
# Time: 2024-03-05T06:02:20.383669Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 10409
# Query_time: 4.436246  Lock_time: 0.000096 Rows_sent: 0  Rows_examined: 227326
SET timestamp=1709618540;
DELETE FROM pre_k_spider WHERE spider_time ＜ ＇1708322535＇;
# Time: 2024-03-05T06:02:20.383696Z
# User@Host: www_huyuzhe_com[www_huyuzhe_com] @ localhost [127.0.0.1]  Id: 10410
# Query_time: 4.237844  Lock_time: 0.000082 Rows_sent: 0  Rows_examined: 0
SET timestamp=1709618540;
REPLACE INTO pre_common_cache SET `cachekey`=＇threadclasscount_130＇ , `cachevalue`=＇a:2:{s:6:\＂sortid\＂;a:5:{i:5;s:1:\＂0\＂;i:7;s:1:\＂0\＂;i:103;s:1:\＂0\＂;i:127;s:1:\＂0\＂;i:90;s:1:\＂0\＂;}s:6:\＂typeid\＂;a:2:{i:586;s:1:\＂0\＂;i:685;s:1:\＂0\＂;}}＇;