EOC Stats back up for now.

From the EOC stats site.

Quote:

As many have noticed the FAH Stats have been down for the past couple days. I've been pruning old historical data in an attempt to get the database under control. The user history table grew to over 1.1 Billion rows, with the table consuming over 36GB!

I've managed to shave it down to around 767 million rows and the table size is now a little under 22GB. There's some tipping point where things really start to balloon if you compare the two pairs of numbers.

Yes I did do a backup before I started removing data, I do plan to eventually re-insert some of it once I get things better organized.

I've un-blocked all the IPs for now. A few people emailed me and I don't think I got a chance to respond back to everyone. If you are still having trouble accessing the XML please send me another email.

I haven't gotten around to the color changes yet, that will probably happen next week.

Be Warned Now... I will be upgrading the database (MySQL) probably this Saturday. Meaning the whole site will be completely down for at least 2-4 hours. I've got to do a complete DB dump / reload because I'm upgrading between versions that are not compatible with leaving the data in the tables.

I'm sure there's more that I can't think of right now, if I remember it I'll be sure to make an additional post.
P.S. for those that want to complain... Realistically this is probably only the second down-time in the past seven or eight YEARS for the stats (that have been MY fault and not Stanford's)... The last time being when I moved the stats to the current server.