2003/09/25
13:02:47
My internal clock is way too messed up right now. I did troubleshooting on the machine that was rebooting. Swapped out the power supply, video card, and even reduced the RAM clock speed to test and nothing seems to work. Looks like we got a bunch of bad motherboards. :( The auth server was being a bit slow at work so I decided to a little cleanup. Dumped one of the logging tables and it came out to over 640MB. Luckily I was able to compress that to around 45MB, but still a ton of data. Then I decided to delete everything before the first of August this year. That seemed to be going OK since nothing needs realtime access to that table, except that a couple hours later all the possible database threads were tied up waiting to drop stuff in there since it was still deleting. Aborted the delete and let them go, and ended up doing it in month chunks rather than all at once. Ended up removing 4.6 million rows, which sped things up a bit just because it wasn't chewing up RAM trying to manage the huge table. Of course then the table apparently hadn't stablized before I upgraded MySQL, so it corrupted. I noticed 2 hours later, but of course inserts on a corrupted table don't work so well so I was only able to recover from before the upgrade. Oh well, at least there were still those 600,000 remaining rows. Looks like I have to put together a couple more kiosk machines for temporary use. Luckily the system is extensible enough I basically just have to give them static IPs and allow the site. The system is nice once it's finished. :) Last night after I came home I started studying for a test this morning. Didn't start until then since I didn't have any materials to study from. Finished up around 1, and the test was at 7am this morning so I had to be on the way by shortly after 6. :( I was done with the test by about 9 (we were given until noon) so hopefully that's a good sign. Guess I'll find out in a couple weeks... Since I had to stick around and wait for my dad to finish I went to Bethel and chatted with people for a while. Dave had 6 people in his office for a while even... Then it was time to grab some ice cream for a snack and head home. Probably to take a nap now...