search

beyond-all-reason / teiserver

Middleware server for online gaming
https://www.beyondallreason.info/
MIT License
47 stars 47 forks source link

Reschedule daily Oban jobs to 8AM instead of 2AM which is still in US peak #288

Closed Beherith closed 2 months ago

Beherith commented 2 months ago 
mean(ms)    count   total(s)    jobname
17ms    9501    170s    Teiserver.Logging.Tasks.PersistServerMinuteTask
100ms   9501    952s    Teiserver.Moderation.RefreshUserRestrictionsTask
1300ms  9501    12353s  Teiserver.Battle.Tasks.PostMatchProcessTask
1113ms  159 177s    Teiserver.Admin.HourlyCleanupTask
494501ms    158 78131s  Teiserver.Battle.Tasks.CleanupTask
120071ms    7   840s    Teiserver.Admin.DailyCleanupTask
122ms   7   0s  Teiserver.Account.Tasks.DailyCleanupTask
424ms   7   2s  Teiserver.Telemetry.EventCleanupTask
1011ms  7   7s  Teiserver.Logging.AggregateViewLogsTask
4384ms  7   30s Teiserver.Logging.Tasks.PersistServerDayTask
28ms    8   0s  Teiserver.Logging.Tasks.PersistServerWeekTask
0ms 7   0s  Teiserver.Logging.Tasks.PersistServerMonthTask
0ms 7   0s  Teiserver.Logging.Tasks.PersistServerQuarterTask
0ms 7   0s  Teiserver.Logging.Tasks.PersistServerYearTask
7513ms  7   52s Teiserver.Logging.Tasks.PersistMatchDayTask
0ms 7   0s  Teiserver.Logging.Tasks.PersistMatchMonthTask
453ms   7   3s  Teiserver.Telemetry.InfologCleanupTask
1297ms  7   9s  Teiserver.Logging.Tasks.PersistUserActivityDayTask
5ms 7   0s  Teiserver.Game.AchievementCleanupTask
16431ms 13  213s    Teiserver.Account.RecalculateUserDailyStatTask
geekingfrog commented 2 months ago

Is this causing problem on the server? Some jobs take a bit of time, but is the DB actually under heavy load? Also, how do you get this useful infodump? Changing the scheduling of these job is trivial but I'd like to better understand the problem to solve here.

Beherith commented 2 months ago

They arent causing direct problems. But 2am is still busy USA time so its sensible to do when quietest