Switch to English Language Passer en langue française Omschakelen naar Nederlandse Taal Wechseln Sie zu deutschen Sprache Passa alla lingua italiana
Members: 74,082   Posts: 1,635,649   Online: 1097
      
Page 6 of 7 FirstFirst 1234567 LastLast
Results 51 to 60 of 70
  1. #51
    zsas's Avatar
    Join Date
    May 2011
    Location
    Chicago, IL
    Shooter
    35mm RF
    Posts
    1,962
    Images
    74
    If your site is affected by gibberish in a 300 page Deleted thread, kill it, we will be happy to start another one....
    Andy

  2. #52
    zsas's Avatar
    Join Date
    May 2011
    Location
    Chicago, IL
    Shooter
    35mm RF
    Posts
    1,962
    Images
    74
    I know just letting Sean know that quarantining or deleting that thread really wd not matter to us. Indexing, parallelism all fun things in DBA land are what are at play....
    Andy

  3. #53

    Join Date
    Mar 2005
    Location
    Tasmania, Australia
    Shooter
    Multi Format
    Posts
    163
    [QUOTE=Sean;1332987]one more find. this sql query is causing the remaining lag:

    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.
    Left/Right/Outer joins can be expensive, more so if the tables aren't indexed for the columns being compared. Sometimes things can be improved by changing the query or by creating/managing an alternative table with less data (which can break normal form rules but I won't tell).

  4. #54
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,690
    Blog Entries
    7
    Images
    15
    ok found the bad code in the sidebar. It was related to "My recent posts" block. I have re-enabled the sidebar but disabled that one block for now. Things seem to be running ok. I am now in contact with vBulletin, turning over all of our config files so they can help us optimize the server. The next couple days I'll be focusing on that. To give you an idea of how the large threads+bad code in the sidebar issue affected us:



    The above chart is for the last 3 days. You can visually see the massive problem arise and fade away once it was resolved. I certainly learned a lot during this drama. I had never really needed to go into the database console to troubleshoot. I have a much better feel now for drilling down to issues from the server application level.

  5. #55
    zsas's Avatar
    Join Date
    May 2011
    Location
    Chicago, IL
    Shooter
    35mm RF
    Posts
    1,962
    Images
    74
    Reading SQL logs is like reading sandscript, thanks for all your 'data gnome catching'. Those 2 min loads were something. Thanks for your efforts, all seems to be zippy and smooth /*knock on wood*/
    Andy

  6. #56
    brucemuir's Avatar
    Join Date
    Dec 2007
    Location
    Metro DC area, USA
    Shooter
    Multi Format
    Posts
    2,266
    Images
    4
    running well here Sean
    thanks for the due diligence!

  7. #57
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,690
    Blog Entries
    7
    Images
    15
    Still running ok. Here is another image of the performance, last 24hrs (the spike on the left is when we had the dramas), you can see on the right how it has settled and response times are fast.



    There could still be a stray monster thread lurking around that will hit us again, but now that I am familiar with tracking them down the impact should be minimal.

  8. #58
    Molli's Avatar
    Join Date
    Dec 2009
    Location
    Victoria, Australia
    Shooter
    Medium Format
    Posts
    549
    It's running perfectly here in Victoria, Australia now, Sean. When I saw the post earlier this morning (3-4am-ish) about database issues, I just steered clear. I can't believe how quickly you've got it up and running again. I "broke" my website numerous times when I was coding WordPress plugins and, even with just a few hundred pages to worry about, that was a nightmare. You have my sincerest commiserations. Digging through code of any type really isn't much fun and this site is massive. Thanks for all of your incredibly hard work - it's truly appreciated.

  9. #59
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,690
    Blog Entries
    7
    Images
    15
    Thanks, just glad it's running well again. Things should improve over the next few days even more. I have some server config files in the hands of vBulletin techs. They are going to help me optimize the server config specifically for the forum software. I also have some additional caching to be installed soon which should further speed up page loads

  10. #60
    Molli's Avatar
    Join Date
    Dec 2009
    Location
    Victoria, Australia
    Shooter
    Medium Format
    Posts
    549
    As someone who has only just switched from a dial up connection, any page that loads within ten minutes is a winner for me Most web sites, I used to sit and play solitaire while waiting for something to show up. I watched my very first YouTube video online (not downloaded to my hard drive over a two hour period) only three weeks ago.

    That admission out there, APUG has always been one of the very few sites that I've enjoyed visiting because page load times are quick (oh that, and the amazingly generous, knowledgeable people who frequent the forum and share their inspiring work!). I lurked for a good year or two before actually signing up and the few hours here and there over the last couple of days where there have been some glitches... well, that's a pretty phenomenal track record, to have it running so smoothly for every other minute of the day for ten years!

Page 6 of 7 FirstFirst 1234567 LastLast


 

APUG PARTNERS EQUALLY FUNDING OUR COMMUNITY:



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