:: 29-Sep-1999 22:25 (Wednesday) ::
I massaged the stats database today. Made a few changes which may or
may not correct our recent difficulties.
First, I gave us another 2GB of space in the stats database. We were
getting a bit low (not uncomfortably so, but still…) on space in
the database and I figured that now was as good a time as any to
make more room. This puts us at 4GB reserved for data, 1GB reserved
for transaction logs.
Second, I completely re-built the main rc5_64_master table. The old
table allowed for nulls in team field, and apparently it’s a bit more
efficient if nulls aren’t allowed in fields, so the new copy of the
table doesn’t allow nulls in any field. There’s no functional difference
for us, since “team 0” is used to denote no team, and it’s impossible to
have a null id, date, or block count.
A necessary aspect of rebuilding rc5_64_master was re-creating all the
indexes as well.
We won’t really know if this helped until tonight’s run (in an hour or
so) — so cross your fingers.
with apache down, everything’s running faster than it was, so I’m hopeful.