📢 Moderators Needed 🚀

Moderators are needed with resources to post or have access to resources to post. Submit an application to be considered.
D

RSS xf_session_activity can end up with too many records (can't be pruned)

  • Thread starter Thread starter digitalpoint
  • Start date Start date
D

digitalpoint

Guest
Guest or Bot
So this was a byproduct of the cron job record going missing (not sure why it went missing, but it did).

By the time I noticed cron jobs weren't running, the xf_session_activity had grown to 2.1M records since it wasn't being pruned. All cron jobs seemed to recover when the record was restored except for the pruning of that table. The table had grown so large that trying to delete 2M+ records in a single query would fail. Ended up doing it manually by deleting 100,000 records...

Read more

Continue reading...
 
P
RSS  [XB] Quizzes [Paid]
V
RSS  Redirection Script for phpBB 3.2/3.3+ (without SEO URLs) htaccess
You must log in or register to reply here.
Similar content Most view View more
Back
Top