Yeah, recent Internal Server Errors are caused by the MySQL server taking absolutely ages to return the queries back to the web server.

It seems like my host doesn't even know what the issue despite many tickets from me; though they keep throwing the blame on me about the queries being bad or whatever, then how come when I can run a replica of Zenius on my four year old computer with only 1gb RAM, it's completely fine? A bit funny isn't it?

I even disabled the site, which some of you may have noticed earlier today, to see if it was Zenius causing it. It turns out it was slow still, get this, it took the MySQL server a whole 120 seconds to show me a list of databases I had, seriously what the hell is up with that? With Zenius disabled and with all linked queries eliminated, it took two minutes just to show me the database and it's tables; You don't expect this from a well known host at all!

They have admitted in the latest ticket to me, there are "other issues" on the MySQL server, which confirms it might not be Zenius that's causing it.

I suggested them transferring me to another MySQL server, but they haven't agreed to it yet. So all I can say is bear with it for now, as my tickets are getting nowhere with DH.

If anyone is generous enough to host the MySQL database, please get in touch, but mind you, it needs to be at a decent speed and more reliable than what's been going on.

Another reason to stop using DreamHost. From what you're saying, I think you should consider switching to PowWeb. They are well known and have a good reputation, from what I read in an article. Check out their hosting package if you want to consider switching hosts.

EDIT: While we're on the topic of MySQL databases, with PowWeb you get 75.

OMG, ZIV is down! How will I ever survive?!
Seriously just do something else for a while. I've never understood why people get irritated over occasional short downtime. Go play some game and check back later.