dz数据库占用满载，慢日志显示dateline代码问题，求方法！ New
2024-2-21 21:32 来自 xiao9469 发布 @ Discuz!问题求助
RT,Dz3.4,有时候cpu占用达到190%！导致社区经常打不开!查询mysql慢日志代码如下！ 这个具体怎么解决，有没有老哥指点一下！复制代码
- SELECT * FROM pre_forum_thread WHERE FROM_UNIXTIME(dateline, ＇%Y-%m-%d＇) = CURDATE() and fid in(＇2＇) AND displayorder ＞=0 ORDER BY views DESC LIMIT 10;# User@Host: www_xxxxx_co @ localhost Id: 68983# Query_time: 3.384782 Lock_time: 0.000089 Rows_sent: 10 Rows_examined: 622055SET timestamp=1708522728;SELECT * FROM pre_forum_thread WHERE FROM_UNIXTIME(dateline, ＇%Y-%m-%d＇) = CURDATE() and fid in(＇2＇) AND displayorder ＞=0 ORDER BY views DESC LIMIT 10;# Time: 240221 21:38:49# User@Host: www_xxxxx_co @ localhost Id: 68985# Query_time: 3.091555 Lock_time: 0.000102 Rows_sent: 10 Rows_examined: 622055SET timestamp=1708522729;SELECT * FROM pre_forum_thread WHERE FROM_UNIXTIME(dateline, ＇%Y-%m-%d＇) = CURDATE() and fid in(＇2＇) AND displayorder ＞=0 ORDER BY views DESC LIMIT 10;# Time: 240221 21:38:56# User@Host: www_xxxxx_co @ localhost Id: 69008# Query_time: 3.325886 Lock_time: 0.000094 Rows_sent: 10 Rows_examined: 622055SET timestamp=1708522736;SELECT * FROM pre_forum_thread WHERE FROM_UNIXTIME(dateline, ＇%Y-%m-%d＇) = CURDATE() and fid in(＇2＇) AND displayorder ＞=0 ORDER BY views DESC LIMIT 10;# User@Host: www_xxxxx_co @ localhost Id: 69006# Query_time: 3.421492 Lock_time: 0.000097 Rows_sent: 10 Rows_examined: 622055SET timestamp=1708522736;SELECT * FROM pre_forum_thread WHERE FROM_UNIXTIME(dateline, ＇%Y-%m-%d＇) = CURDATE() and fid in(＇2＇) AND displayorder ＞=0 ORDER BY views DESC LIMIT 10;# User@Host: www_xxxxx_co @ localhost Id: 69015# Query_time: 3.344995 Lock_time: 0.000093 Rows_sent: 10 Rows_examined: 622055SET timestamp=1708522736;SELECT * FROM pre_forum_thread WHERE FROM_UNIXTIME(dateline, ＇%Y-%m-%d＇) = CURDATE() and fid in(＇2＇) AND displayorder ＞=0 ORDER BY views DESC LIMIT 10;# Time: 240221 21:39:03# User@Host: www_xxxxx_co @ localhost Id: 69031# Query_time: 5.658589 Lock_time: 0.000089 Rows_sent: 10 Rows_examined: 622055SET timestamp=1708522743;SELECT * FROM pre_forum_thread WHERE FROM_UNIXTIME(dateline, ＇%Y-%m-%d＇) = CURDATE() and fid in(＇2＇) AND displayorder ＞=0 ORDER BY views DESC LIMIT 10;# Time: 240221 21:39:04# User@Host: www_xxxxx_co @ localhost Id: 69032# Query_time
- 最近查阅:
免责声明：
DZ插件网AI平台旨在开源共享精神，请勿发布敏感信息，任何违法信息我们将移交公安机关；
上一篇： 发帖没有上传图片按钮 New
