Tweet
This is in my slow query log... over and over and over, except the LIMIT increments by 30 each time. It takes 12 seconds to run each time it runs (and it constantly runs). Maybe not coincidentally, I am having serious load issues right now:
SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,IF((NOT(options & 1024) AND (user.usergroupid IN (-1))), 0, reputation) AS reputationscore,level
, IF((options & 512 AND user.userid <> 0), 1, 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 reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputationlevelid)
WHERE 1=1
AND user.usergroupid IN (-1,6,9,7,2,5)
ORDER BY user.username asc
LIMIT 153120, 30;
Where is that coming from? Some scheduled task or something? Could this be from people looking at the member listing pages?
Ryan
SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,IF((NOT(options & 1024) AND (user.usergroupid IN (-1))), 0, reputation) AS reputationscore,level
, IF((options & 512 AND user.userid <> 0), 1, 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 reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputationlevelid)
WHERE 1=1
AND user.usergroupid IN (-1,6,9,7,2,5)
ORDER BY user.username asc
LIMIT 153120, 30;
Where is that coming from? Some scheduled task or something? Could this be from people looking at the member listing pages?
Ryan
Comment