Tasks in DB

Bernd Machenschalk
Bernd Machenschalk
Moderator
Administrator
Joined: 15 Oct 04
Posts: 4312
Credit: 250570845
RAC: 34530
Topic 196765

It seems that the large number of tasks (3.7M) is seriously stressing our databases (not only the replica).

For the time being I changed the configuration of the project such that the time "finished" workunits and tasks are kept in the DB is reduced from 7d to 5d.

This means you have less time to inspect your tasks e.g. after validation, but it should reduce the number of tasks we need to keep in our DB in total and make the DBs more responsive.

BM

BM

TPCBF
TPCBF
Joined: 24 Nov 12
Posts: 17
Credit: 221017025
RAC: 1544269

Tasks in DB

Quote:

It seems that the large number of tasks (3.7M) is seriously stressing our databases (not only the replica).

For the time being I changed the configuration of the project such that the time "finished" workunits and tasks are kept in the DB is reduced from 7d to 5d.

This means you have less time to inspect your tasks e.g. after validation, but it should reduce the number of tasks we need to keep in our DB in total and make the DBs more responsive.

BM

Could that be a possible reason why the stats on BOINCStats aren't updating for more than a day now?

Ralf

Bernd Machenschalk
Bernd Machenschalk
Moderator
Administrator
Joined: 15 Oct 04
Posts: 4312
Credit: 250570845
RAC: 34530

RE: Could that be a

Quote:
Could that be a possible reason why the stats on BOINCStats aren't updating for more than a day now?

I don't think so. According to the logs stats export was done twice a day without errors for at least the past 4d. Last dump was finished on 10:46 UTC today.

BM

BM

TPCBF
TPCBF
Joined: 24 Nov 12
Posts: 17
Credit: 221017025
RAC: 1544269

RE: RE: Could that be a

Quote:
Quote:
Could that be a possible reason why the stats on BOINCStats aren't updating for more than a day now?

I don't think so. According to the logs stats export was done twice a day without errors for at least the past 4d. Last dump was finished on 10:46 UTC today.

BM

Stats at BOINCstats just for E@H updated for the first time in two days last night for me...

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.