Affiliate Guard Dog - Gone?

[winbig]

This is a very interesting one. The site is now on my server and is up. But the forum is extremely slow. Currently troubleshooting with my hosts. Not sure if it is a resource issue ie lack of them, or a software issue.

As long as it's using a known fast database server, I would suspect that the code is the culprit. Just for shits and giggles, I'd suggest changing out the VB skin (set it back to the default VB skin w/o plugins) that AGD uses and see if that makes a difference.

On the other hand, if you only moved the site itself and not the database, I'd strongly suggest importing the database to the server on your host and changing the VB config files to use that database. That would definitely cause it to be slow..

[Webzcas]

This is like light speed in comparison.

Looking like a coding issue. Many erroneus requests being constantly made to the database.

I don't believe it to be hardware resources however, otherwise all my sites which use mysql would be hanging in mid air. Which they are not.

As for vb, it still is as slow as anything with the default vb skin. One of the first things tested.

[winbig]

As for vb, it still is as slow as anything with the default vb skin. One of the first things tested.

What about mods/add-ons?

[Webzcas]

A couple more things need to be tested. Including a call I am going to place with vbulletin. Running 'top' from an ssh shell, shows mysql seriously eating into the cpu, looks like some pretty intensive queries being constantly run.

Will update here and on the AGD forum. But today is Sunday and I promised my boy I will take him on a train to the 'big park' in Bath. We might also go into a toy shop too

[Webzcas]

AGD Forums are now back up and running properly.

[winbig]

AGD Forums are now back up and running properly.

So what was causing the problems? Inquiring minds want to know

[Webzcas]

So what was causing the problems? Inquiring minds want to know

A webstats database, which had grown extremely large. The forum was writing to it and updating it on every activity. Thus waiting for a response from it, before responding to the visitor. Hence the large number of sleep processes for the forum.