Switch to English Language Passer en langue française Omschakelen naar Nederlandse Taal Wechseln Sie zu deutschen Sprache Passa alla lingua italiana
Members: 70,301   Posts: 1,536,152   Online: 816
      
Page 5 of 8 FirstFirst 12345678 LastLast
Results 41 to 50 of 73
  1. #41
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,555
    Blog Entries
    7
    Images
    15
    Quote Originally Posted by David A. Goldfarb View Post
    APUG--brought down by the "deleted" and joke threads. Well, those would be no great loss.
    Could be. The server still seems twitchy but since removing those big threads it's been somewhat usable. If you stumble across any giant threads might be good idea to lock them for now or move them to the "compost heap" so we can keep track of them. When the dust settles we'll try moving them back in, locking them and making a "part2" for them.

  2. #42
    Sirius Glass's Avatar
    Join Date
    Jan 2007
    Location
    Southern California
    Shooter
    Multi Format
    Posts
    13,095
    Quote Originally Posted by Sean View Post
    Things seem improved after moving a few mega-threads from view. What I noticed was the site running fine, then a big slow down. After gaining access to the mysql database process log, every time the site went slow there would be a thread id in the queued processes. Each id corresponded to an extremely large thread. Threads like "your latest 35mm camera purchase" or the "deleted" thread. There were several Kodak ones as well. I'll get these threads back into view soon but locked down and we can create a "part2" for them. For now seems safest to stash them away. It's still hard to tell 100% if that was the issue.
    Oh no! Say it ain't so! Not the DELETED thread!
    Warning!! Handling a Hasselblad can be harmful to your financial well being!

    Nothing beats a great piece of glass!

    I leave the digital work for the urologists and proctologists.

  3. #43
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,555
    Blog Entries
    7
    Images
    15
    one more find. this sql query is causing the remaining lag:

    [quote] Copying to tmp table | SELECT DISTINCT t.threadid,t.title
    FROM post AS p
    LEFT JOIN thread AS t ON (p.threadid=t.threa |{/quote]

    Trying to find out what component in our software is generating this. I think once we can get rid of that things will be a lot better.

  4. #44
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,555
    Blog Entries
    7
    Images
    15
    The above may have been generated by the sidebar. I have disabled the sidebar for now to see how it goes.

  5. #45
    papagene's Avatar
    Join Date
    Jun 2004
    Location
    Western Mass., USA
    Shooter
    Multi Format
    Posts
    5,190
    Images
    116
    Site performance seems spotty this morning, sometimes taking a minute or so to load a page.
    gene LaFord


    Long live Ed "Big Daddy" Roth!!
    ---------------------------------------------------------------------
    "I don't care about Milwaukee or Chicago." - Yvon LeBlanc

  6. #46
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,555
    Blog Entries
    7
    Images
    15
    Quote Originally Posted by papagene View Post
    Site performance seems spotty this morning, sometimes taking a minute or so to load a page.
    How is it as of right now?

  7. #47
    flatulent1's Avatar
    Join Date
    Oct 2008
    Location
    Seattle USA
    Shooter
    Multi Format
    Posts
    1,285
    Seems okay here.
    Fred Latchaw
    Seattle WA


    I am beginning to resent being referred to as 'half-fast'.
    Whatever that's supposed to mean.

  8. #48
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,555
    Blog Entries
    7
    Images
    15
    Hopefully things will run ok for now. It seems the main culprits have finally been identified. Gotta get some sleep, then the next couple days see if we can get things back to normal.

  9. #49
    zsas's Avatar
    Join Date
    May 2011
    Location
    Chicago, IL
    Shooter
    35mm RF
    Posts
    1,959
    Images
    74
    Been here for about ten mins, all is nice n fast
    Andy

  10. #50
    markbarendt's Avatar
    Join Date
    May 2008
    Location
    Ignacio, CO, USA
    Shooter
    Multi Format
    Posts
    5,687
    Blog Entries
    3
    Images
    19
    I can see things again, yea.
    Mark Barendt, Ignacio, CO

    "We do not see things the way they are. We see things the way we are." Anaïs Nin

Page 5 of 8 FirstFirst 12345678 LastLast


 

APUG PARTNERS EQUALLY FUNDING OUR COMMUNITY:



Contact Us  |  Support Us!  |  Advertise  |  Site Terms  |  Archive  —   Search  |  Mobile Device Access  |  RSS  |  Facebook  |  Linkedin