AGD Forum Issues

Discussion in 'General Casino Affiliate Area' started by Webzcas, Jul 31, 2010.

  1.  
    Webzcas

    Webzcas Affiliate Guard Dog Member

    Messages:
    392
    Likes Received:
    167
    Joined:
    Nov 13, 2008
    Forum performance is still poor. I am currently hosting the site on my dedicated server and my hosts are looking into this. The load doesn't actually seem that great on the server. But we are ascertaining whether a server upgrade is indeed the right course of action. As all my sites hosted on the same server including two vbulletin forums are responding find.

    All forum modifications have been stripped back whilst troubleshooting is carried out.

    Will keep you posted.

    Dave
     
  2.  
    Webzcas

    Webzcas Affiliate Guard Dog Member

    Messages:
    392
    Likes Received:
    167
    Joined:
    Nov 13, 2008
    Testing 123
     
  3.  
    dominique

    dominique Certification Member

    Messages:
    1,072
    Likes Received:
    4
    Joined:
    Dec 18, 2006
    Loading like a snail....but at least it's here again! :)
     
  4.  
    Webzcas

    Webzcas Affiliate Guard Dog Member

    Messages:
    392
    Likes Received:
    167
    Joined:
    Nov 13, 2008
    Not sure how long it will take for you to be able to read this. :)

    Ok, last course of action before the inevitable server upgrade :eek:

    I am going to be logging a call with VBulletin. Now I have ssh access to my server again. I will optimise VB per their instructions.

    Running top from the ssh shell. Shows MYsql is hammering the cpu of the server, constantly. Looks like a load of intensive queries are constantly being run on the db's on guard dog.

    My hosts have done all that they can do. VBulletin are the last course of hope software wise, unless Andy can track back the changes to the site he made 6 months ago when the forum started to grind to a halt.

    If after implementing all the changes to the server recommended by vbulletin no discernable improvement is arrived at. Then I get a new toy in the shape of a new dual processor quad core server. ;D

    As it is Sunday, I am out with my boy today, but will be on this tonight and tomorrow. One way or another tomorrow should have this problem resolved or at least improved.
     
  5.  
    Webzcas

    Webzcas Affiliate Guard Dog Member

    Messages:
    392
    Likes Received:
    167
    Joined:
    Nov 13, 2008
    Problem identified and resolved.

    There are a few issues with the forum. One being vbseo. But I'm working on that.

    The main thing is, the forum is flying now. :)
     
  6.  
    dominique

    dominique Certification Member

    Messages:
    1,072
    Likes Received:
    4
    Joined:
    Dec 18, 2006
    Yep, going fast! :) Thank you so much!!!!
     
  7.  
    Webzcas

    Webzcas Affiliate Guard Dog Member

    Messages:
    392
    Likes Received:
    167
    Joined:
    Nov 13, 2008
    Testing quickreply.
     
  8.  
    Guard Dog

    Guard Dog Guard Dog Staff Member

    Messages:
    7,727
    Likes Received:
    1,152
    Joined:
    Dec 13, 2006
    Tons of thanks goes to Webczas for finally figuring this out. What a relief!!!! This took a lot of effort and is so much appreciated!
     
  9.  
    Engineer

    Engineer Super Moderator

    Messages:
    2,443
    Likes Received:
    200
    Joined:
    Dec 14, 2006
    Hats off to you, Dave. This is great. I'm dying to know, though, what specifically was the problem? Inquiring minds want to know... :rolleyes:
     
  10.  
    Webzcas

    Webzcas Affiliate Guard Dog Member

    Messages:
    392
    Likes Received:
    167
    Joined:
    Nov 13, 2008
    A small matter of a very large webstats DB being written to whenever there was any activity on the forum. With over 2.5million records in one table alone. So the forum db would wait for a response from it before continuing. Hence the long delays.

    This has now been disabled.
     
  11.  
    Engineer

    Engineer Super Moderator

    Messages:
    2,443
    Likes Received:
    200
    Joined:
    Dec 14, 2006
    Wow -- who knew! :eek: I'm glad it's sorted now.
     
  12.  
    Bonus Paradise

    Bonus Paradise Affiliate Guard Dog Member

    Messages:
    730
    Likes Received:
    98
    Joined:
    Mar 30, 2008
    Amazing! it loads super fast!
    Very glad for you Andy!
    Thank you Webzcas!
     
    Last edited: Aug 2, 2010
  13.  
    Pokerkeep

    Pokerkeep Affiliate Guard Dog Member

    Messages:
    141
    Likes Received:
    0
    Joined:
    Nov 3, 2008
    Much better!! Well done Webzcas. Thanks for getting this sorted.
     
  14.  
    GFPC

    GFPC BWIN IS ROGUE

    Messages:
    398
    Likes Received:
    0
    Joined:
    Feb 5, 2010
    Yeah so much faster. I love it! Excellent Job man!!

    You are from heaven!!

    Super fast!
     

Share This Page