讯睿CMS问答:服务器卡的要死  看慢日志结果

讯睿CMS问答:服务器卡的要死 看慢日志结果

2024-09-07 XunRuiCMS Sincere

问题:

服务器卡的要死 看慢日志结果:

[05-Jun-2023 22:28:05] [pool www] pid 6112

script_filename = /www/wwwroot/www.XXXXX.com/index.php

[0x00007f4ff901fbc0] query() /www/wwwroot/www.XXXXX.com/dayrui/CodeIgniter/System/Database/MySQLi/Connection.php:292

[0x00007f4ff901fa50] execute() /www/wwwroot/www.XXXXX.com/dayrui/CodeIgniter/System/Database/BaseConnection.php:666

[0x00007f4ff901f9c0] simpleQuery() /www/wwwroot/www.XXXXX.com/dayrui/CodeIgniter/System/Database/BaseConnection.php:593

[0x00007f4ff901f550] query() /www/wwwroot/www.XXXXX.com/dayrui/Fcms/Core/View.php:1306

[0x00007f4ff901f270] _query() /www/wwwroot/www.XXXXX.com/dayrui/App/Module/Action/Modules.php:164

[0x00007f4ff901d970] [INCLUDE_OR_EVAL]() /www/wwwroot/www.XXXXX.com/dayrui/App/Module/Action/Related.php:30

[0x00007f4ff901d600] [INCLUDE_OR_EVAL]() /www/wwwroot/www.XXXXX.com/dayrui/Fcms/Core/View.php:1252

[0x00007f4ff901a790] list_tag() /www/wwwroot/www.XXXXX.com/cache/template/template_DS_pc_DS_bmb_DS_home_DS_tag_DS_tag.html.cache.php:171

[0x00007f4ff9019cf0] [INCLUDE_OR_EVAL]() /www/wwwroot/www.XXXXX.com/dayrui/Fcms/Core/View.php:272

[0x00007f4ff90194d0] display() /www/wwwroot/www.XXXXX.com/dayrui/App/Tag/Controllers/Home.php:115

[0x00007f4ff90187a0] tag() /www/wwwroot/www.XXXXX.com/dayrui/App/Tag/Controllers/Home.php:12

[0x00007f4ff90186c0] index() /www/wwwroot/www.XXXXX.com/dayrui/CodeIgniter/System/CodeIgniter.php:927

[0x00007f4ff90184f0] runController() /www/wwwroot/www.XXXXX.com/dayrui/CodeIgniter/System/CodeIgniter.php:482

[0x00007f4ff9017db0] handleRequest() /www/wwwroot/www.XXXXX.com/dayrui/CodeIgniter/System/CodeIgniter.php:351

[0x00007f4ff9017960] run() /www/wwwroot/www.XXXXX.com/dayrui/CodeIgniter/Init.php:106

[0x00007f4ff9017490] [INCLUDE_OR_EVAL]() /www/wwwroot/www.XXXXX.com/dayrui/Fcms/Init.php:491

[0x00007f4ff90152f0] [INCLUDE_OR_EVAL]() /www/wwwroot/

www.XXXXX.com/index.php:51

完全看不懂。。。

答案:

从日志来看是你模板中的标签写法不当导致,特别是用度了modules标签

参考文档:《MySQL数据优化》

回复@迅睿框架技术-小白 之前的是{module catid=$catid order=updatetime page=10} 改成{module catid=$catid order=updatetime page=1} 好像好点了 不知道对不对

这个很简单在模板里面做排除法删除标签,然后看快不快,如果删除了一些变快的话,那说明你删除了这些标签就有问题呀,需要优化

@迅睿框架技术-小白:感谢 排除了