Re: Cache-based "who is online"
Reply #1 –
just an idea (not fully related but it may help Fixing the issue): Have you tried changing the table engine to MEMORY?
Re: Cache-based "who is online"
Reply #4 –
Wow ... thats quite a few. Why the 1min setting, is that to try and keep the list down to size due to it being so active?
Re: Cache-based "who is online"
Reply #5 –
TBH I'm not entirely sure...
Re: Cache-based "who is online"
Reply #6 –
You're saying 1 minute is the timeout for them being online? That would mean that every minute 300 unique users are accessing the site. That is a massive site. I'm betting the query cache is enabled. So, you're updating that as well. Did you try the MEMORY engine?
Re: Cache-based "who is online"
Reply #8 –
TBH I forgot about altering the table until a couple of days ago I got about 6000 emails in a matter of minutes... lol
Well, now is memory, though it didn't solve that much, I just got 482 slow queries and about 95% of them were related to the log_online table...