Older stats issue

[Bok]

They are still running, but I chose to do some maintenance today on the gargantuan host weekly table to split it into years and it's taking a VERY long time to delete out the older years. In fact the query has been running for 12 hours now This is causing major slowdowns on the rest of the updates.

In hindsight I should have just copied the table over to another machine and done it like that.

It had 750million rows in it and this one is the main cause of the 'sunday' slowdown so that will hopefully be a bit better tomorrow and LOT better next week once I finish.

So let's just hang on and hopefully it'll complete soon. If it's not finished in the next couple of hours though I'm going to kill it..

Bok

[John Galt 007]

Have they stopped exporting stats? Just a bit curious, as my stats haven't updated since this weekend. Thanks...

[Bok]

yup.

No changes to the xml in 3 days now.

[John Galt 007]

yup.

No changes to the xml in 3 days now.

Guess there was a change now...stats updated...

Nice work, Bok...

Thanks...

[vaughan]

Bok something strange has happened to the BOINC Combined Users stats today. The first 18 people all scored 1 Billion points (well nine hundred and ninety eight thousand million or so in English or a Trillion points in US nomenclature)!

Edit: It appears to be Seti Beta that is the cause of the aberration.

[zombie67]

Bok something strange has happened to the BOINC Combined Users stats today. The first 18 people all scored 1 Billion points (well nine hundred and ninety eight thousand million or so in English or a Trillion points in US nomenclature)!

I saw that too. Something very odd.

[Bok]

yeah. Seti Beta has really fsck'd it up.

I'll fix those users up later today