Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 20 Oct 2010, 18:14
OcR Envy's Avatar
OcR Envy OcR Envy is offline
 
Join Date: May 2008
Real name: Ryan
set lastactivity on a big board

I'm running into some slow queries with setting lastactivity on a big board that I develop for(1,285 concurrent users at the time of this post). This is a default vBulletin installation with very little modification.

Examples:








I've never noticed a problem in any of the smaller boards I run but this one seems to be locking up during peak times and it's all do to these queries. So I took a look and found in core_class.php on line 3,640:

// if this line is removed (say to be replaced by a cron job, you will need to change all of the 'online'
// status indicators as they use $userinfo['lastactivity'] to determine if a user is online which relies
// on this to be updated in real time.
My first thought is just set a cache or cookie/timeout to only update lastactivity say once every 10 minutes. However after reading that I'm wondering how often does 'real time' mean. I would assume it's based on what our cookie_timeout is set to, yes?

Any suggestions on what the problem is, how to resolve it, or any work around examples would be greatly appreciated.
Reply With Quote
  #2  
Old 25 Oct 2010, 14:21
OcR Envy's Avatar
OcR Envy OcR Envy is offline
 
Join Date: May 2008
Real name: Ryan
Bump, anyone?
Reply With Quote
  #3  
Old 12 Dec 2010, 10:34
VinavB's Avatar
VinavB VinavB is offline
 
Join Date: Sep 2010
whois can help fixed it ???
Reply With Quote
  #4  
Old 02 Jan 2011, 15:50
newmark newmark is offline
 
Join Date: Sep 2010
same problem.
anyone who fixes?
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 19:10.

Layout Options | Width: Wide Color: