|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Hi. I have some big problem with my mysql server, the server load is going nuts. Having problem with this queries # Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 613322 SELECT SUM(IF(lastvisit >= 1263996911, 1, 0)) AS active, COUNT(*) AS users, MAX(userid) AS maxid FROM user; # Query_time: 10 Lock_time: 0 Rows_sent: 30 Rows_examined: 1839053 SELECT user.*,usertextfield.*,userfield.*, user.userid, options, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid ,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight , IF((options & 512 AND user.userid 0), 0, lastactivity) AS lastvisittime FROM user AS user LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid) LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) WHERE 1=1 AND (user.usergroupid IN (-1,6,30,34,5,7,29,2,32,3)) ORDER BY user.username asc LIMIT 406590, 30; __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |