I forget the title but there’s a line that goes, “You don’t know, you can’t know what I’ve done to be here.” That’s exactly how I feel after dealing with server overload for the past week or two.
For all you bloggers dying to upgrade to WordPress 2.5, you might learn a thing or two. I’ve been through hell and back, spent so many consecutive sleepless nights that I have lost count, and it looks like I need to dive in again to finally see the light. See, Pinoy Moms Network is still offline and I have some really serious problems.
I am on a dedicated server. All the accounts in it are mine. About a week or so ago, the server started to slow down. Now, that happens. Sometimes, traffic spikes. Sometimes, spammers hit you bad. Sometimes, hackers inject malicious scripts. Other times, it’s a technical glitch. When the server overloaded in the past, it usually took a few hours to get it stable. But not this time. It was a recurring problem.
A lot of other things happening in the WordPress blogging community made my webhost think it was a case of need-to-upgrade to the latest version of WordPress. Apparently, Technorati dropped a lot of blogs from it rolls following security issues discovered recently in the older versions of WordPress. So, you know, I thought I was just one of the many although I wasn’t hit by the Technorati ban.
Then, there were rumors about theme sites injecting scripts into the templates of free WordPress themes and redistributing them to the public. There were scripts that were supposed to redirect traffic to the blasted re-distributor. For a blogging community that is highly dependent on free themes and free plug-ins, that is a nightmare.
Finding the problem was hard. Of course, I had help from Yuga, but the process of elimination was long and painful. Did I have plug-ins that didn’t work with version 2.5? They were all functional but the pages were loading oh, so slowly. Eventually, I had to remove the Translator Plugin that was translating the recipes in Pinoy Cook into 13 languages. Then, I removed Recent Comments, Related Posts, Post Views and User Online. Shit, that really hurt.
Then, I had to suspend the accounts one by one to find out which was causing the overload. When things like this happen, Yuga first points his fingers at this blog. You know, with so many people I piss off with my writing, it sounds logical. If it isn’t a malicious attack on this blog, he thinks it’s too much traffic on Pinoy Cook. But all logic escaped us this time. The source of the overload was Pinoy Moms Network and it wasn’t because of high traffic.
Thing is, I still don’t know the exact problem. I only know that whenever I try to put it back online, the server overloads, slows down and unless rebooted, it dies. It’s going to be a long, long week ahead.
Oh, the clincher, I almost forgot. The magazine-type layouts that use SQL queries on the front page instead of the usual WordPress “loop”? Seems they eat up server resources like anything. Until I find some good solutions, I suppose it’s safest to stick with the boring WordPress loop for now.