Stories
Slash Boxes
Comments

SoylentNews is people

posted by on Tuesday January 08 2019, @04:32PM   Printer-friendly
from the spit-and-baling-wire dept.

After a morning of slow query logging and cussing, a misplaced "GROUP BY" that was turning a 0.04 second query into one that took over fifteen seconds has been fixed. I'll leave the slow query log running overnight though just to make sure I didn't miss any less common ones. If you're still seeing any serious site slowdowns, let us know.

 
This discussion has been archived. No new comments can be posted.
Display Options Threshold/Breakthrough Mark All as Read Mark All as Unread
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
  • (Score: 2) by Pino P on Wednesday January 09 2019, @12:41AM (5 children)

    by Pino P (4721) on Wednesday January 09 2019, @12:41AM (#783919) Journal

    "Invalid form key" might happen if you click Reply and then wait several hours before submitting.

    Starting Score:    1  point
    Karma-Bonus Modifier   +1  

    Total Score:   2  
  • (Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @12:50AM (4 children)

    by The Mighty Buzzard (18) Subscriber Badge <themightybuzzard@proton.me> on Wednesday January 09 2019, @12:50AM (#783924) Homepage Journal

    Or if you change IP addresses, yep.

    --
    My rights don't end where your fear begins.
    • (Score: 2) by Runaway1956 on Wednesday January 09 2019, @03:19AM (1 child)

      by Runaway1956 (2926) Subscriber Badge on Wednesday January 09 2019, @03:19AM (#783964) Journal

      I've seen both of those. Type a reply, get called away by the wife, come back and hit submit. Or change to VPN, or disconnect from VPN. Both easily solved - hit the "back" button, copy what you had typed, then reload the topic to which you were responding, hit the "reply" button again. It's a mild irritant, might really piss some other people off.

      • (Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @04:27AM

        by The Mighty Buzzard (18) Subscriber Badge <themightybuzzard@proton.me> on Wednesday January 09 2019, @04:27AM (#783979) Homepage Journal

        It'd probably be a good idea to ditch it for all registered users, honestly. If they get their spam on we have a damned easy recourse, so there's not really a need for them. Cleanup would still be annoying but not insurmountable.

        --
        My rights don't end where your fear begins.
    • (Score: 2) by Pino P on Wednesday January 09 2019, @02:15PM (1 child)

      by Pino P (4721) on Wednesday January 09 2019, @02:15PM (#784104) Journal

      If I'm commenting while riding the city bus, then my IP address will change depending on what hotspots my laptop or phone happens to pick up at the time. Could the form key IP address check be made less stringent for logged-in users, or for excellent-karma logged-in users? Or is it considered a measure against account compromise?