Database problems
Feb.19, 2010 in
blogging
Chinese new year happened over here and I didn’t have any internet access over the last week or so.
So naturally one of my wordpress plugins realises I’m not around and decided to go rogue and place undue stress on the hosting database. Hosting company then realise this and disable the database until I get in touch with them.
All fixed now.
February 19th, 2010 at 2:29 pm Suzie(Quote)
Oh good, you’re back. I wondered what had happened. Hope the celebrations were great.
February 19th, 2010 at 4:00 pm ozsoapbox(Quote)
Yeah it’s been a pretty busy week for me. Didn’t have any internet so I didn’t even know the site was down until my mum managed to get through on my phone and it came up in conversation lol.
Love it how these sorts of things always happen when you’re not around to fix them!.
Celebrations have been good so far, lots of material to blog about!
February 19th, 2010 at 7:52 pm Elbowgrease(Quote)
Glad to see you back Oz.
For a horrible moment I thought you may have fallen prey to senator Conroys All Seeing Eye.
February 19th, 2010 at 8:23 pm Yi(Quote)
yeah u had us all worried.
February 19th, 2010 at 11:35 pm ozsoapbox(Quote)
The problem was with the plugin ‘Yet Another Related Post Plugin’ (YARPP) hammering the MYSQL database with too many requests.
I’ve installed a cache plugin and turned off YARPP displaying related posts on the RSS feed but I’m not sure if that’s enough. I asked my hosting company for clarification if there’s some way I can monitor the server load myself to see how it’s going. Still waiting on a reply.
If the site goes down again this will be the reason so I’ll have to disable YARPP permanently and look for another plugin that’s less server intensive. It’s a shame really as I quite like the way YARPP matches up content from different posts.
February 20th, 2010 at 2:12 am Bryan(Quote)
glad to see you back. i thought for a few days there that shane kryder and the ‘ologist’s finally got you to take down your site:) i am glad to see that is not the case.
February 20th, 2010 at 2:15 am Vince(Quote)
February 20th, 2010 at 2:17 am Vince(Quote)
^
Tried to show you a command there to try… dunno if you can see it
February 20th, 2010 at 7:23 pm ozsoapbox(Quote)
It’s come up as blank, is it a html command or php? You can try email it.
February 20th, 2010 at 10:56 pm Vince(Quote)
php..
echo exec(‘uptime’);
February 20th, 2010 at 11:37 pm ozsoapbox(Quote)
What am I doing with that command?
Sorry if that’s a stupid question but my hosting is in the US and I only have http access to the databases etc.
They sent me a message saying there’s no way for me to manually monitor the server so I’ll just have to wait and see if the changes have any effect or if the database gets taken down again.
February 21st, 2010 at 11:31 am Vince(Quote)
That’s just a php command you can use within a php file. I use it to see the server load, although it shows the overall load, not just what you’re using.
But, if your host uses Cpanel, that will show your cpu and memory usage when you login.
Other than that, I’m not sure if there’s another way to check.
February 21st, 2010 at 1:44 pm ozsoapbox(Quote)
Cool.
I’ll leave it for now and see if they suspend it again. So far so good.
I’ll come back to it if the site goes down again.