ahkscript.org forum seems extremely slow

[vasili111]

Another error:

[tank]

Thanks that is extremely helpfull.
Give me a couple days to investigate

[joedf]

First time for me...

Code: Select all

	
General Error
SQL ERROR [ mysqli ]

Unknown MySQL server host 'ahknew.db.9104519.hostedresource.com' (2) [2005]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

[PuzzledGreatly]

I'm seeing the Unknown MySQL server host 'ahknew.db.9104519.hostedresource.com' (2) [2005] error nearly all the time when I'm logged in. Even got it when I tried to log out. I have better luck viewing the forum if I am not logged in. Tank mentioned this could be browser specific. It might be useful to mention the browser when reporting problems. I've tried Pale Moon 24.5 on two different computers with the same problems. Can anyone report a browser they are not having trouble with? Thanks

[lexikos]

I doubt very much that the random slowness and server errors have anything to do with which browser you're using. The speed issues, at least, definitely affect Chrome 34, IE8 and Firefox 22 (on this XP system). When it happens, occasionally a page will still load quickly, but mostly not.

[just me]

Same here (Chrome 34 / Firefox 27 on Win 8.1 (x64).

[joedf]

Right. SQL is a server-side problem not client-side. If it were a client-side problem, then we would see these same error messages on other websites too.
- Firefox 28

[tank]

it is and unfortunately it seems to be a semi common problem for high traffic on shared hosts

[vasili111]

Received error:

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host

[tank]

ok thanks guys this seems to be a consistent round of DB errors regardless of the DB
Im searching for a solution

[joedf]

Well whooP-ity-doop, yesterday it was completely down for me... The error page was showed constantly for the forum.

[tank]

hardware upgrade went badly
is the performance even better?

[joedf]

I'll have to test it. >:D

[xZomBie]

Seems to be faster than before.

[just me]

Yes, it seems to be overall faster.

@tank: You're talking about a 'shared host' (i.e. a virtual machine). How much more would it cost to have a dedicated server?

[Morpheus]

Much faster for me today.

[joedf]

Now it seems faster... But yesterday, it exploded for me... It was like the website never existed... I presume the website was migrated to
another server. So the DNS over here probably just got updated later... well anyways it's back online for me now

tank, you the man.
I have to say : "tank you" hehe

[tank]

Yes the ip changed so it was likely dns propagation.

Justme. The cost difference is substatial, about 130 ish per month that has to be paid a full year at a time. I have a bit of experience with this and performance wise we would need 2 servers to see long lasting improvement. Separate device for db and web services. Lets see how we do where we are for now first before jumping off a bridge. I was given a rather interesting idea for using ads and monetising a hidden replica of the site that can only be seen if the ip is one of the many we block from ddos and spam attempts. If I can make it work we might be able to use heavy spam activity to our advantage and build a funding mechinism

[joedf]

GENIUS!

[xZomBie]

[ . . . ] I was given a rather interesting idea for using ads and monetising a hidden replica of the site that can only be seen if the ip is one of the many we block from ddos and spam attempts. If I can make it work we might be able to use heavy spam activity to our advantage and build a funding mechinism

I'm imagining tank with an evil lough! I support this idea.