升級后php7.4 mysql5.7打開首頁幾分鐘

sdfarmer

本來挺快的，不知道怎么回事突然變慢了






如何排查是哪個文件或者哪個插件執行慢

我知道答案 回答被采納將會獲得1 貢獻 + 1 金幣 已有7人回答

ink

lnmp環境么？看看PHP和MYSQL慢日志就大概知道原因了

sdfarmer

ink 發表于 2023-3-20 15:04
lnmp環境么？看看PHP和MYSQL慢日志就大概知道原因了

謝謝，我看看，前后臺登陸都特別慢

sdfarmer

ink 發表于 2023-3-20 15:04
lnmp環境么？看看PHP和MYSQL慢日志就大概知道原因了

[20-Mar-2023 15:01:25]  [pool www] pid 8056
script_filename = /www/wwwroot/www.baidu.com/bbs/misc.php
[0x00007f3ddc613880] query() /www/wwwroot/www.baidu.com/bbs/source/class/db/db_driver_mysqli.php:141
[0x00007f3ddc6137a0] query() /www/wwwroot/www.baidu.com/bbs/source/class/discuz/discuz_database.php:142
[0x00007f3ddc6136e0] query() /www/wwwroot/www.baidu.com/bbs/source/class/discuz/discuz_database.php:78
[0x00007f3ddc6135b0] update() /www/wwwroot/www.baidu.com/bbs/source/class/discuz/discuz_table.php:57
[0x00007f3ddc6134e0] update() /www/wwwroot/www.baidu.com/bbs/source/class/table/table_forum_forum.php:115
[0x00007f3ddc613430] update() /www/wwwroot/www.baidu.com/bbs/source/include/cron/cron_todaypost_daily.php:29
[0x00007f3ddc613320] [INCLUDE_OR_EVAL]() /www/wwwroot/www.baidu.com/bbs/source/class/discuz/discuz_cron.php:48
[0x00007f3ddc613230] run() /www/wwwroot/www.baidu.com/bbs/source/class/discuz/discuz_application.php:592
[0x00007f3ddc6131a0] _init_cron() /www/wwwroot/www.baidu.com/bbs/source/class/discuz/discuz_application.php:71
[0x00007f3ddc613140] init() /www/wwwroot/www.baidu.com/bbs/misc.php:91

ink

sdfarmer 發表于 2023-3-20 15:15
[20-Mar-2023 15:01:25]   pid 8056
script_filename = /www/wwwroot/www.baidu.com/bbs/misc.php
[0x000 ...

慢日志，不是錯誤日志，mysql的慢日志應該是如下這種：


# Time: 2023-03-20T20:05:09.829660+08:00
# User@Host: ***[*** @ localhost [127.0.0.1]  Id: 1239068
# Query_time: 3.255740  Lock_time: 0.000037 Rows_sent: 0  Rows_examined: 0
SET timestamp=1679313909;
INSERT INTO pre_forum_hotreply_number SET `pid`='3536540' , `tid`='451408' , `support`='0' , `against`='0' , `total`='0';
# Time: 2023-03-20T20:05:09.846345+08:00
# User@Host: ***[dmc051344] @ localhost [127.0.0.1]  Id: 1239055
# Query_time: 3.354575  Lock_time: 0.000055 Rows_sent: 20  Rows_examined: 102105
SET timestamp=1679313909;
SELECT * FROM pre_forum_thread  WHERE `fid`='158' AND `displayorder` IN('0','1')  ORDER BY displayorder DESC, lastpost DESC    LIMIT 19360, 20;

niuniu1688

重新配置一下環境

sdfarmer

ink 發表于 2023-3-20 20:09
慢日志，不是錯誤日志，mysql的慢日志應該是如下這種：

這個是php慢日志

false001

被攻擊了？？？？？？？？？