服务器最近负载一直挺高,mysql占用cpu不时的达到99%,查看慢查询日志,主要都是
[ol]SELECT itemid,title,thumb,linkurl,style,catid,areaid,introduce,addtime,edittime,username,company,groupid,vip,qq,msn,ali,skype,validated,price,unit,minamount,amount FROM destoon_sell WHERE status=3 ORDER BY editdate desc,vip desc,edittime desc LIMIT 89240,20;[/ol]复制代码
[ol]SELECT itemid,title,thumb,linkurl,style,catid,areaid,introduce,addtime,edittime,username,company,groupid,vip,qq,msn,ali,skype,validated,price,unit,minamount,amount FROM destoon_sell WHERE status=3 AND keyword LIKE '%防腐剂%' ORDER BY editdate desc,vip desc,edittime desc LIMIT 27500,20;[/ol]复制代码
[ol]SELECT itemid,title,thumb,linkurl,style,catid,introduce,addtime,edittime,username,islink FROM destoon_article_21 WHERE status=3 AND keyword LIKE '%北虫草%' ORDER BY addtime desc LIMIT 0,30;[/ol]复制代码
基本都是以上三类,开启全文搜索也没什么效果,请问有什么办法改善一下啊。。。 |