mysqld有时候占用CPU搞,请高手指导
Remysqld有时候占用CPU搞,请高手指导
是的,是DZ程序
经常是MYSQL锁死,表现为网页曼或者打不开
-------------------------
Remysqld有时候占用CPU搞,请高手指导
一直在论坛等着大神回复,希望二楼的朋友能指导一下
-------------------------
回1楼sunfei的帖子
????
-------------------------
Remysqld有时候占用CPU搞,请高手指导
没有人帮我,都太势力了
-------------------------
回8楼ivmmff的帖子
ecs双核2g内存3m带宽
-------------------------
Re:回 9楼(kanghuaiqia) 的帖子
引用第10楼ivmmff于2015-11-06 13:40发表的 回 9楼(kanghuaiqia) 的帖子 :
InnoDB 都关闭了,内存也那么大,还搞满。。
我觉得程序的问题,有语句错误,导致重复查询或者写入数据库 [url=http://bbs.aliyun.com/job.php?action=topost&tid=262286&pid=724821][/url]
慢查询里面有几句可疑
# Query_time: 55.031954 Lock_time: 0.000000 Rows_sent: 10 Rows_examined: 743696
SET timestamp=1446710609;
select a.tid,a.subject,a.dateline,a.views,a.replies,a.author,a.authorid,b.message from pre_forum_thread a join pre_forum_post b on a.tid=b.tid where a.attachment!=0 and a.displayorder>=0 and b.first=1 order by tid desc limit 0,10;
# Time: 151105 16:04:18
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 46.578721 Lock_time: 0.000000 Rows_sent: 10 Rows_examined: 743698
SET timestamp=1446710658;
select a.tid,a.subject,a.dateline,a.views,a.replies,a.author,a.authorid,b.message from pre_forum_thread a join pre_forum_post b on a.tid=b.tid where a.attachment!=0 and a.displayorder>=0 and b.first=1 order by tid desc limit 0,10;
不知道是DISCUZ哪里调用的这两句,非常奇怪
赞0
踩0