staff blogs

distributed.net staff keep (relatively) up-to-date logs of their activities in .plan files. These were traditionally available via finger, but we've put them on the web for easier consumption.

2002-03-08

decibel [08-Mar-2002 @ 02:49]

Filed under: Uncategorized — decibel @ 02:49 +00:00

:: 08-Mar-2002 02:49 GMT (Friday) ::

And there was much rejoicing.

Sybase 11.0.3 can’t optimize stored procedures very well, which was causing a
problem for the participant history page. Every time someone hit that page, it
would cause the database to read a substantial portion of the (now 52 million
row) Email_Contrib table. Not only would it take forever to get that page back,
but all of that disk IO was seriously impacting the server itself.

Anyway, I’ve replaced the stored proc with a raw query (so much for code
abstraction), and everything seems to be running OK again.

2002-03-07

decibel [07-Mar-2002 @ 07:46]

Filed under: Uncategorized — decibel @ 07:46 +00:00

:: 07-Mar-2002 07:46 GMT (Thursday) ::

Blower is quite unhappy with the rc5 data in the new table format.
Specifically, web site access is generating a huge amount of disk IO. Based on
a quick check of page load times, the problem seems to be on the email side,
rather than the team’s side.

I’ve updated index statistics on all the major tables used by the new stats
system, but that didn’t help.

We’re going to have to try and figure out what queries are taking so long to
run from the website. Until we can do that, things are going to run a bit slow.
Hopefully we can get this cleaned up in the next week or so. In the meantime,
expect web access to be turned off at times to facilitate the statsruns.

decibel [07-Mar-2002 @ 04:14]

Filed under: Uncategorized — decibel @ 04:14 +00:00

:: 07-Mar-2002 04:14 GMT (Thursday) ::

Blower is still unhappy. I’m updating index statistics on the off-chance that
will fix the problem. More info as available.

2002-03-06

decibel [06-Mar-2002 @ 08:10]

Filed under: Uncategorized — decibel @ 08:10 +00:00

:: 06-Mar-2002 08:10 GMT (Wednesday) ::

Blower’s been running terribly slow on the RC5 data for Mar 4, so I’ve shut
off the website for the next two hours. Hopefully it will be well caught up by
then.

2002-03-05

decibel [05-Mar-2002 @ 23:34]

Filed under: Uncategorized — decibel @ 23:34 +00:00

:: 05-Mar-2002 23:34 GMT (Tuesday) ::

There will be a brief network outage at UD tonight. This will affect stats and
cvsweb.

decibel [05-Mar-2002 @ 03:40]

Filed under: Uncategorized — decibel @ 03:40 +00:00

:: 05-Mar-2002 03:40 GMT (Tuesday) ::

Now that we have 52 million rows in the main table for the new stats system,
it’s become obvious that we need to re-optimize things a bit. In order to do
this, I’ll be turning off web access for a while. I hope this will take less
than 2 hours. Sorry for the inconvenience.

2002-03-04

decibel [04-Mar-2002 @ 00:56]

Filed under: Uncategorized — decibel @ 00:56 +00:00

:: 04-Mar-2002 00:56 GMT (Monday) ::

Master is once again listening to blower, so OGR should start processing RSN.

2002-03-03

decibel [03-Mar-2002 @ 20:53]

Filed under: Uncategorized — decibel @ 20:53 +00:00

:: 03-Mar-2002 20:53 GMT (Sunday) ::

Stats are back up. There is still a persistent problem with retrieving
OGR logs from the master, though. The issue is that blower’s IP isn’t
reversing. UD’s operations department has contacted the upstream
providers, who should have had this fixed Friday.

bovine [03-Mar-2002 @ 11:10]

Filed under: Uncategorized — bovine @ 11:10 +00:00

:: 03-Mar-2002 11:10 GMT (Sunday) ::

Just thought I’d include a link to Bug 2469 just so that people would
be aware of some of the outstanding issues with the planfile system.
http://n0cgi.distributed.net/bugs/show_bug.cgi?id=2469

decibel [03-Mar-2002 @ 06:02]

Filed under: Uncategorized — decibel @ 06:02 +00:00

:: 03-Mar-2002 06:02 GMT (Sunday) ::

Murphy is alive and well it seems. After upgrading blower to FBSD4.5, php no
longer wants to talk to sybase. This is most likely due to the hacks that
were made to get PHP to talk to sybase in the first place. Unfortunately, the
person who set this up in the first place isn’t around tonight, so the odds of
it getting fixed tonight aren’t too good. He’ll probably be around tomorrow,
though, and I’m hoping that he’ll recognize what PHP is doing and be able to
fix it quickly. Until then, don’t expect anything useful out of stats. :(

« Newer Posts — Older Posts »