Brent Dax (brentdax) wrote,
Brent Dax

Fighting the system

When I checked my e-mail I was in for an unpleasant surprise—I had about fifty e-mails telling me that an every-ten-minutes cron job used to maintain Navi's access_log_today table had failed. I tried to SSH in, but the server was incredibly unresponsive, so I had to wander upstairs to fix it.

The server still wasn't very responsive. I eventually determined that it wasn't CPU, the network wasn't looking odd, and the RAID array was just dandy. A quick check online revealed that access_log_today was probably corrupt. That would explain it—Apache tries to insert a record into that table every time someone accesses a page. I killed the Apache processes (they wouldn't shut down properly via init script), and the hard drive light immediately stopped flashing. I then repaired the table and deleted the records in it for good measure. When I restarted Apache it ran just fine.

Dear Lazyweb,

Is there anything I can do to ensure that this sort of thing doesn't slow the machine down so much that it takes several minutes to execute a command? I'm using MySQL 4.0.22, Apache 2.0.5something, and Linux 2.6.something.

Thanks, Brent.

  • Paging madlori (and anyone who knows her)

    An interesting thing just happened on Facebook chat. Lori Summers [2:29:44] Got my message ? Brent Royal-Gordon [2:33:45] I did. Lori Summers…

  • guest post

    kate is the best better than the rest the best the best haikus about kate: kate's my favourite i want to lick her ballsack it would taste so…

  • Practice

    This December, I will have been practicing programming seriously for ten years. That will mark the tenth anniversary of me starting to learn Perl. I…

  • Post a new comment


    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.