Penny Arcade Forums› H.Q. Reception Desk
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Holiday Forums are now up. Let me (Hahnsoo1) know if there are any issues. The Holiday Forum merge will last (if Vanilla cooperates) until January 3rd.

The forums seem slow.

erisian popeerisian pope Registered User regular
edited April 2004 in H.Q. Reception Desk
Or is it just me? I am getting very long delays when trying to open topics in any forum here. Could this relate to the recent mySQL change and subsequent clock resync?

Is this the HomeLAN clock issue again?

Pete-sig-1.jpg
My Website | My "photo-a-day" 2010
erisian pope on

Posts

  • erisian popeerisian pope Registered User regular
    edited April 2004
    It appears to be fixed. Thank you, you mysterious fixer whoever you are!

    erisian pope on
    Pete-sig-1.jpg
    My Website | My "photo-a-day" 2010
  • StevenSteven Registered User regular
    edited April 2004
    Forums slow during peak hours, what the shit could it be?!

    Steven on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    Sometimes the forums are fast, sometimes they are slow. On comic strip days during peak times the PHP part of this slows way down. The MySQL part is consistently fast, but the PHP part I have seen page gen times from .2sec to roughly 120sec

    I have teamed up with Ramius to see what can be dont to speed up the forums, but our solution is a pretty well kept secret. You will feel the speed change when we implement it.

    But, until then there is nothing I can do. If you notice a certain page is slower than others, post it in here and I will take a look.

    Älphämönkëy on
  • CorvusCorvus . VancouverRegistered User regular
    edited April 2004
    Not a slowness issue per se, but I have been getting Cricitcal Errors: Could not connect to database aprox 50% of the time I try to access the forums tonight.

    Corvus on
    :so_raven:
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    psych71 wrote:
    Not a slowness issue per se, but I have been getting Cricitcal Errors: Could not connect to database aprox 50% of the time I try to access the forums tonight.
    Really? Are you having it right now?

    Älphämönkëy on
  • LegacyLegacy Stuck Somewhere In Cyberspace The Grid(Seattle)Registered User, ClubPA regular
    edited April 2004
    Yeah.

    They've been running great lately, but this was a "can't even get close to loading a page" slowness today...

    Legacy on
    Can we get the chemicals in. 'Cause anything's better than this.
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    Ah. I see. There was a hung sql connection. It had an idle time of roughly an hour.

    Älphämönkëy on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    Oh. Shit. I see why the posting sometimes takes forever. Its the searching tool. Hmmmmm....

    Älphämönkëy on
  • Munkus BeaverMunkus Beaver You don't have to attend every argument you are invited to. Philosophy: Stoicism. Politics: Democratic SocialistRegistered User, ClubPA regular
    edited April 2004
    phpBB : Critical Error

    Error creating new session

    I got that message a while ago.

    Munkus Beaver on
    Humor can be dissected as a frog can, but dies in the process.
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    Ah. That was someone sesssion flodding us. I put a stop to that.

    Älphämönkëy on
  • LegacyLegacy Stuck Somewhere In Cyberspace The Grid(Seattle)Registered User, ClubPA regular
    edited April 2004
    :^::^::^:

    Legacy on
    Can we get the chemicals in. 'Cause anything's better than this.
  • CorvusCorvus . VancouverRegistered User regular
    edited April 2004
    alphamonkey wrote:
    psych71 wrote:
    Not a slowness issue per se, but I have been getting Cricitcal Errors: Could not connect to database aprox 50% of the time I try to access the forums tonight.
    Really? Are you having it right now?

    Nope, just when I was trying to get into the forums, once i was in it was fine. Glad to see you dealt with the flooder.

    Corvus on
    :so_raven:
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    alphamonkey wrote:
    Oh. Shit. I see why the posting sometimes takes forever. Its the searching tool. Hmmmmm....
    Ok, this is going to get very technical...

    The slow point lies in the wordlist thingy. When searching it locks the word list preventing edits\posts\replies while someone is searching.

    Im looking into some things, one idea is to change the search select statements to LOW_PRIORITY, but for some reason that scares me. I fear that the select will never complete as we will be constantly recieving inserts and updates.

    The other idea I had is to change all the INSERTS to DELAYED. It will speed things up alot if I understand the concept. It might make a slight delay so right after you post there will be a little delay before it appears. Hmmm... If coupled with the above LOW_PRIORITY it should prove to be stable. At least in theroy.

    My question is, to the MySQL informed, what are your takes on it. I know the theroy is good, but I hesistate before bringing this out into a live environment.

    Älphämönkëy on
  • OrthancOrthanc Death Lite, Only 1 Calorie Off the end of the internet, just turn left.Registered User, ClubPA regular
    edited April 2004
    I'm not rite up with what MySQL can and can't do, if that delayed insert works like I think it will, you'll only need it on the inserts into the word list. The post could still appear immediatly, it just won't be searchable for a while.

    Orthanc on
    orthanc
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited April 2004
    Orthanc wrote:
    I'm not rite up with what MySQL can and can't do, if that delayed insert works like I think it will, you'll only need it on the inserts into the word list. The post could still appear immediatly, it just won't be searchable for a while.
    True. I only need to make part of it delayed. I was thinking about it as an all or nothing thing.... Hmmm.... I likes this.... This is now the top of my todo.

    Älphämönkëy on
  • LegacyLegacy Stuck Somewhere In Cyberspace The Grid(Seattle)Registered User, ClubPA regular
    edited April 2004
    alphamonkey wrote:
    Orthanc wrote:
    I'm not rite up with what MySQL can and can't do, if that delayed insert works like I think it will, you'll only need it on the inserts into the word list. The post could still appear immediatly, it just won't be searchable for a while.
    True. I only need to make part of it delayed. I was thinking about it as an all or nothing thing.... Hmmm.... I likes this.... This is now the top of my todo.

    *shakes fist*

    Spoilers! :P heh

    Legacy on
    Can we get the chemicals in. 'Cause anything's better than this.
Sign In or Register to comment.
Penny Arcade Forums› H.Q. Reception Desk