fyi- Some APUG functionality disabled due to bad code and performance issues.

Discussion in 'APUG System Announcements' started by Sean, Apr 22, 2012.

  1. Sean

    Sean Admin Staff Member Admin

    Messages:
    9,296
    Joined:
    Aug 29, 2002
    Location:
    New Zealand
    Shooter:
    Multi Format
    Hi All,

    Unfortunately some APUG custom 3rd party plugins have proven to be extreme problems for the server's performance. These plugins will need to be investigated and likely re-coded. I'll try to have this done as soon as possible.

    Plugins that have been temporarily disabled due to issues:

    sidebar: latest posts,
    sidebar: latest gallery image,
    Selective Forum Filter (which lets you hide some forums from view),
    random image block on gallery home page,

    At this moment the site seems to be really flying. This was the result of some extensive examination into the database activity and removing anything causing huge performance hits. Also, sever key server parameters have been adjusted.

    Hopefully the current performance will continue. Thanks for your patience while sorting this out, no fun for all involved.

    Sean
     
  2. zsas

    zsas Member

    Messages:
    1,961
    Joined:
    May 12, 2011
    Location:
    Chicago, IL
    Shooter:
    35mm RF
    Last hour has been great! Was in gallery and it was fast, general forum is fast, sent a PM and it worked. All seems good. Thanks for all your efforts triaging, quarantining and such.
     
  3. Sean

    Sean Admin Staff Member Admin

    Messages:
    9,296
    Joined:
    Aug 29, 2002
    Location:
    New Zealand
    Shooter:
    Multi Format
    This might be the fastest we've been in a long time. Latency was 500-600ms average for the last several days or worse, have now gotten things down to 150-200ms and most things snapping into place. There is still one rogue database query related to the gallery that has me pulling my hair out. This one query causes a scan of 38,000 db records every time and it happens a lot. I have sent the output to the gallery software tech to see if we can squash this. I have newrelic monitoring installed now and a screen in my office with a live view of the newrelic monitoring graphs. This is great as with one glance I can tell all is running good.
     
  4. MattKing

    MattKing Subscriber

    Messages:
    16,799
    Joined:
    Apr 24, 2005
    Location:
    Delta, BC, Canada
    Shooter:
    Multi Format
    Sean:

    Do you ever wish you had some time for the darkroom?

    Can you think of anything we can do to help?
     
  5. Sean

    Sean Admin Staff Member Admin

    Messages:
    9,296
    Joined:
    Aug 29, 2002
    Location:
    New Zealand
    Shooter:
    Multi Format
    Thanks Matt. Well, things have just been crazy lately. Moving Islands, trying to get settled down here with the family. I was just starting to get caught up with the backlog from the move/house purchase/renovations then got hit with these server issues. I'm hoping the dust settles quite a bit over the next few weeks. I guess if anyone knows a billionaire film shooter that wants to take a stake in APUG and hire 3 staff for us feel free to give them my email :tongue:
     
  6. Sean

    Sean Admin Staff Member Admin

    Messages:
    9,296
    Joined:
    Aug 29, 2002
    Location:
    New Zealand
    Shooter:
    Multi Format
    Here is my new real time monitoring setup so I can keep a much closer eye on things. I just leave this running all day now. New Relic monitoring is pretty cool, I need to work on some of the alerts so it will just page me out when things go wrong.

    [​IMG]
     
  7. Sean

    Sean Admin Staff Member Admin

    Messages:
    9,296
    Joined:
    Aug 29, 2002
    Location:
    New Zealand
    Shooter:
    Multi Format
    sorry guys, things slowing down again so disabled the gallery to rule that out. I think this server is just not agreeing with us. I've never had issues like this in nearly 10 years. Worst case we'll migrate back to a dedicated server in the next few days.
     
  8. MattKing

    MattKing Subscriber

    Messages:
    16,799
    Joined:
    Apr 24, 2005
    Location:
    Delta, BC, Canada
    Shooter:
    Multi Format
    Sean:

    Just thought I would post to say thanks for the chance to see the new posts appearing from the Dutch Threads.

    I cannot understand them at all, but they look interesting :wink:
     
  9. Gerald C Koch

    Gerald C Koch Member

    Messages:
    6,239
    Joined:
    Jul 12, 2010
    Location:
    Southern USA
    Shooter:
    Multi Format
    The groups listing still comes up empty for me. Very annoying!
     
  10. Rick A

    Rick A Subscriber

    Messages:
    7,417
    Joined:
    Mar 31, 2009
    Location:
    northern Pa.
    Shooter:
    Multi Format
    Would that I had some spare $$$ I'd come down and help get the remods on the house buttoned up. I'm a retired contractor. At the very least, I will add some extra funds when renewal time arrives(soon). All you other folks out there need to help out as well. All you freeloading "members" need to pony up for a scrip!
     
  11. brucemuir

    brucemuir Member

    Messages:
    2,266
    Joined:
    Dec 25, 2007
    Location:
    Metro DC are
    Shooter:
    Multi Format
    I think paring down on some features may be the right direction.

    Just my opinion.

    Once again Sean, thanks for your dedication.