ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 29,517
- Points
- 823
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
Read more
Continue reading...
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...