Where did this list at the bottom of the forum page go? I found it quite useful for knowing who was online and active in a discussion.

 

Ya know what? I was thinking the same thing. Maybe it has to do with recent events?

 

I think it has to do with some of our perfomance problems as of late. Less queries are being sent with it off for now as silvrhand figures out what the issues are.

 

Yes,

I was removing some option to try to troubleshoot the nasty query that was killing us. I think I have found a good balance for now, as the board grows and grows it becomes increasing difficult to keep a lot of some neat features.

Counting all session id's and then displaying them per forum and in alphabetical order is a very expensive query.

 

So is this feature within posts gone for good?

 

Maybe in the short term, we are addign some more memory to the box next week so it'll return after that. Plus I'm still working on tweaking some things here and there.

 

Is this getting recalculated on each page view? If so, it can probably be cached to a tempfile so it's only performed once every minute (or maybe 30-90 seconds) at most.

 

why would u need to see who's viewing the thread or who's in that forum? it personally did not benefit to me so if that is what's slowing down the site, i'm glad it's gone. with that said, i still get a "site to busy" sign sometimes. i got one today earlier.

 

The problem is you you can't cache a query in MySQL that uses current time which it does to figure out the session information. Caching it to a file would be very nasty as it's different per thread!

I've tuned some more mySQL server settings tonight, we are creating a TON of temp tables which may be cause of the join buffer size being only 1M, which vbulletin does a lot of joins. Hoping this will stop the temp table creation, I'm still also having trouble getting the query_cache to stick more than about 40%, I was hoping to cache more of the queries off. More tuning, reading, research, etc, etc to go.