1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

so i dont post or browse much on hondaswap anymore

Discussion in 'Members' Lounge' started by TurboMirage, Oct 13, 2008.

  1. TurboMirage

    TurboMirage YEEAAAHHH VIP

    Messages:
    24,577
    Likes Received:
    696
    Joined:
    May 20, 2003
    Location:
    Central, MA
    its just too slow. even with my 2 T1s at the office i click and wait wait wait. when i get home its even worse.

    its actually slower than myspace most of the time. anyone else with this issue?
     
  2. AHHVTEC

    AHHVTEC Well-Known Member VIP

    Messages:
    13,122
    Likes Received:
    245
    Joined:
    Oct 13, 2006
    Location:
    Alabama
    here and there it gets slow on me but for the most part is ok, but when it does get slow its real slow and stays that way for about a day
     
  3. reckedracing

    reckedracing TTIWWOP VIP

    Messages:
    21,056
    Likes Received:
    1,180
    Joined:
    Dec 5, 2002
    Location:
    NY
    no speed issues for me
    myspace blows for speed
     
  4. INJEN78

    INJEN78 HS LEGEND

    Messages:
    9,187
    Likes Received:
    121
    Joined:
    Oct 1, 2007
    Location:
    OHIO
    mine is never slow..
     
  5. Briansol

    Briansol Admins Admin VIP

    Messages:
    21,449
    Likes Received:
    2,110
    Joined:
    Nov 18, 2007
    Location:
    CT
    it's the gf thread.

    it's why i closed it.


    i'm aware of the issue
     
  6. AHHVTEC

    AHHVTEC Well-Known Member VIP

    Messages:
    13,122
    Likes Received:
    245
    Joined:
    Oct 13, 2006
    Location:
    Alabama
    it just done it again with me kicked me all the way off this time and i had to log back in.
     
  7. Briansol

    Briansol Admins Admin VIP

    Messages:
    21,449
    Likes Received:
    2,110
    Joined:
    Nov 18, 2007
    Location:
    CT
    i just restarted mysql, thats why
     
  8. TurboMirage

    TurboMirage YEEAAAHHH VIP

    Messages:
    24,577
    Likes Received:
    696
    Joined:
    May 20, 2003
    Location:
    Central, MA
  9. AHHVTEC

    AHHVTEC Well-Known Member VIP

    Messages:
    13,122
    Likes Received:
    245
    Joined:
    Oct 13, 2006
    Location:
    Alabama
  10. INJEN78

    INJEN78 HS LEGEND

    Messages:
    9,187
    Likes Received:
    121
    Joined:
    Oct 1, 2007
    Location:
    OHIO
    im not having any problems
     
  11. reikoshea

    reikoshea HS Troll...And Mod Moderator VIP

    Messages:
    12,633
    Likes Received:
    193
    Joined:
    Apr 27, 2005
    Location:
    San Antonio, TX
    a lot better today than it usually is. dunno why youd have to ever restart mysql unless you made a change to my.cnf...but thats a discussion for a different time and place
     
  12. Briansol

    Briansol Admins Admin VIP

    Messages:
    21,449
    Likes Received:
    2,110
    Joined:
    Nov 18, 2007
    Location:
    CT
    vbulletin has issues with large threads.

    it ends up doing a select where postid IN ( all, post, id, of, the, entire, thread, here)

    add 1000 post id's to that query and you can imagine what happens.

    then, factor that it was the most popular thread at one point...


    it's tough to decipher.

    loads are low (.4)
    mem usage is good (30%)

    throwing more hardware at it won't fix the issue.
     
  13. TurboMirage

    TurboMirage YEEAAAHHH VIP

    Messages:
    24,577
    Likes Received:
    696
    Joined:
    May 20, 2003
    Location:
    Central, MA
  14. Briansol

    Briansol Admins Admin VIP

    Messages:
    21,449
    Likes Received:
    2,110
    Joined:
    Nov 18, 2007
    Location:
    CT
    yeah, because i re-started stuff this morning, which killed any random or rouge connections to that thread.
     
  15. jamesA

    jamesA Well known pissed off telephone guy VIP

    Messages:
    16,118
    Likes Received:
    1,016
    Joined:
    Aug 10, 2003
    yeah i have had issues as well.
     
  16. oneofakinduserid

    oneofakinduserid Eh?

    Messages:
    294
    Likes Received:
    18
    Joined:
    May 28, 2008
    Location:
    Mebane, NC
    I've never had a problem with HS.. except when I accidently double click the search button and it makes me wait five seconds before letting me continue. Overall I'm happy with the site, great job guys =)
     
  17. reikoshea

    reikoshea HS Troll...And Mod Moderator VIP

    Messages:
    12,633
    Likes Received:
    193
    Joined:
    Apr 27, 2005
    Location:
    San Antonio, TX
    mysqladmin proc;
    mysqladmin kill [long waiting proc id]
     
  18. Briansol

    Briansol Admins Admin VIP

    Messages:
    21,449
    Likes Received:
    2,110
    Joined:
    Nov 18, 2007
    Location:
    CT
    no, its not even that.


    here's what's happens...


    someone views the gf thread.... mysql does its thing, locking tables.
    basically, the delay is you waiting for that huge query which locked the post table to finish and then it's your turn to get the resources to run the query.

    The rest of the page loads super fast. it's just that waiting period for mysql to be able to 'release' the lock on the post table.

    There's no good way to fix it. I'm hoping in a few days when it drops back to page 2, we will have less issues.
     
  19. reikoshea

    reikoshea HS Troll...And Mod Moderator VIP

    Messages:
    12,633
    Likes Received:
    193
    Joined:
    Apr 27, 2005
    Location:
    San Antonio, TX
    we have that same problem with our app at work. I do the above to the query locking all the tables, then voila.

    Another way to fix it would be to run InnoDB tables instead of MyISAM, but even then you might have the same problem and an overall slower responding site. I got what you mean. Maybe make a separate section with a different DB connect to take GF Pic thread out of searches or thread loads.
     
  20. Briansol

    Briansol Admins Admin VIP

    Messages:
    21,449
    Likes Received:
    2,110
    Joined:
    Nov 18, 2007
    Location:
    CT
    easier said than done.

    if anything, i'll move the thread into a private forum so no one can look at it :)
     
Verification:
Draft saved Draft deleted

Share This Page