Puakma: Under the hood

I'm Brendon Upson, jack-of-all-trades, master of one or two. I'm talking about life running a small ISV tackling business issues and leaping technology hurdles in a single bound.

webWise Network Consultants is based in Sydney, Australia and develops the groundbreaking Tornado Server technology.

Corruption!

Filed under: by Brendon Upson on 2005-09-23

Yesterday puakma.net started behaving in an odd manner. Poor performance, using all the memory of the server and mysql abruptly abending. Not happy. Luckily I was able to shut everything down and run myisamchk to repair the system database. Whew. One thing I did notice during the check was the thousands of deleted records still hanging about in the database. I was under the impression mysql took care of all these records, but it would appear that you need to run myisamchk to remove them. I know with postgresql a regular run of "VACUUM FULL VERBOSE ANALYZE" definitely improved database performance, especially on a database that receives a lot of inserts.

Puakma.net is running Fedora Core 2 which is definitely getting old. There's been a ton of kernel changes since FC2 so maybe its time to upgrade...