private async Task PerformStatsGcAsync()
{
logger.Info(() => $"Performing stats DB cleanup");
await cf.Run(async con =>
{
// MinerNL Stats cleanup
var _StatsDBCleanupHistory = clusterConfig.Statistics?.StatsDBCleanupHistory ?? statsDBCleanupHistory;
if (_StatsDBCleanupHistory == 0)
{
_StatsDBCleanupHistory = statsDBCleanupHistory;
logger.Info(() => $"statistics -> statsDBCleanupHistory not found in config.json. using default : {statsDBCleanupHistory} days");
}
logger.Info(() => $"Removing all stats older then {_StatsDBCleanupHistory} days");
var cutOff = DateTime.UtcNow.AddDays(-_StatsDBCleanupHistory);
// MinerNL end
var rowCount = await statsRepo.DeletePoolStatsBeforeAsync(con, cutOff);
if (rowCount > 0)
{
logger.Info(() => $"Deleted {rowCount} old poolstats records");
}
rowCount = await statsRepo.DeleteMinerStatsBeforeAsync(con, cutOff);
if (rowCount > 0)
{
logger.Info(() => $"Deleted {rowCount} old minerstats records");
}
});
logger.Info(() => $"Stats cleanup DB complete");
}
private async Task PerformStatsGcAsync()
{
logger.Info(() => $"Performing Stats GC");
await cf.Run(async con =>
{
var cutOff = DateTime.UtcNow.AddMonths(-3);
var rowCount = await statsRepo.DeletePoolStatsBeforeAsync(con, cutOff);
if (rowCount > 0)
{
logger.Info(() => $"Deleted {rowCount} old poolstats records");
}
rowCount = await statsRepo.DeleteMinerStatsBeforeAsync(con, cutOff);
if (rowCount > 0)
{
logger.Info(() => $"Deleted {rowCount} old minerstats records");
}
});
logger.Info(() => $"Stats GC complete");
}