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.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
(1)
(1)
(Score: 5, Insightful) by fyngyrz on Tuesday January 08 2019, @04:43PM
Looks seriously improved from this end.
Kudos!
--
Cats have 32 muscles in each ear to ignore you with
(Score: 2) by takyon on Tuesday January 08 2019, @04:58PM (8 children)
Please put in a 30-second page load delay thanks.
[SIG] 10/28/2017: Soylent Upgrade v14 [soylentnews.org]
(Score: -1, Flamebait) by Anonymous Coward on Tuesday January 08 2019, @05:32PM (6 children)
Nosql is the clear answer. Group by clauses, set theory, and the relational model are for old white incels. Soylent should be hip and diverse and web-scale!
(Score: 2) by Freeman on Tuesday January 08 2019, @06:08PM (5 children)
Oh, you mean, they should find some way to use an excel spreadsheet for all their database needs?
Joshua 1:9 "Be strong and of a good courage; be not afraid, neither be thou dismayed: for the Lord thy God is with thee"
(Score: 3, Funny) by khallow on Tuesday January 08 2019, @08:34PM (4 children)
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @08:46PM (3 children)
CSV
works for me!
(Score: 2) by The Mighty Buzzard on Tuesday January 08 2019, @11:46PM (2 children)
Let's try the lost art of compromise. CSV in an Excel spreadsheet. Best to be on the safe side and encapsulate it in XML too.
My rights don't end where your fear begins.
(Score: 4, Funny) by maxwell demon on Wednesday January 09 2019, @06:45AM (1 child)
But only if the XML is encapsulated in JSON.
The Tao of math: The numbers you can count are not the real numbers.
(Score: 0) by Anonymous Coward on Wednesday January 09 2019, @11:02AM
Fine, so long as you then serialize it with YAML [wikipedia.org]
(Score: 2) by Pino P on Wednesday January 09 2019, @12:39AM
If you need the spacebar heating [xkcd.com], install a Monero miner.
(Score: 3, Insightful) by Snow on Tuesday January 08 2019, @04:59PM (2 children)
Not all heros wear capes, but I feel that TMB does from time to time.
(Score: 2) by The Mighty Buzzard on Tuesday January 08 2019, @05:10PM
Naw, my Underoos are all SpiderMan until I feel like finding and shelling out the cash for some Deadpool ones.
My rights don't end where your fear begins.
(Score: 0) by Anonymous Coward on Wednesday January 09 2019, @11:09AM
Nooooooo
he'll get sucked into a hurricane!
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @06:34PM (6 children)
Great, thank you. Now if you could make the site no longer look and perform like total crap on Android and iOS mobile devices, that would be swell.
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @06:53PM (2 children)
it works as it should on my android device
(Score: 0) by Anonymous Coward on Wednesday January 09 2019, @03:14AM (1 child)
That's odd - it was designed to NOT WORK on Android. TMB should check that out.
(Score: 0) by Anonymous Coward on Wednesday January 09 2019, @11:16AM
You mean iCrap, right?
(Score: 0) by Anonymous Coward on Wednesday January 09 2019, @11:07AM (2 children)
Use Android Mobile Firefox.
When they introduced the new + for expanding comments it broke on other browsers.
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @11:24AM (1 child)
First I've heard of it. We tested a pretty good range of browsers but we only have so many phones between us to test with.
My rights don't end where your fear begins.
(Score: 0) by Anonymous Coward on Wednesday January 09 2019, @01:23PM
FWIW, I use Brave Browser on both Android and iOS. Many times the site displays in very tiny text. Zooming only makes the text slightly larger. Other times, it's fine. Also, when posting, many times the entire text box envelopes all of the buttons, including "Preview" and "Submit," making it very difficult to see and access the buttons. Sometimes it is impossible to see and access the buttons while trying to post.
(Score: 2) by istartedi on Tuesday January 08 2019, @06:41PM (19 children)
I haven't had a slowdown, but just now I had a couple loads where it looked like a 1998 web page with no formatting. I hit ctrl-refresh a couple times and it didn't work. I went to my profile and it was properly formatted, then went back to the front page and it was OK. Maybe the bad query was in my cache and just needed some time to flush. Ooops-spoke too soon. Got a 404 when I hit submit. Let's try again...
Appended to the end of comments you post. Max: 120 chars.
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @06:56PM
#metoo: https://soylentnews.org/index.pl?issue=20190107 [soylentnews.org]
(Score: 2) by bzipitidoo on Tuesday January 08 2019, @07:02PM
Same here, right after I submitted a comment. Even got a weird message that my comment had been moved "here".
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @07:21PM (11 children)
I'd like the "Invalid form key" errors to go away. I'm not behind a proxy or firewall (unless my ISP is doing weird things), nor did I did the damn back key. I can not determin any pattern on my end for when the errors occur. It is quite frustrating. I wonder if it only happens to those of us posting as AC.
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @11:26PM
I see those once in 50 posts or so. I don't know why it would happen more with others, when I am using a Frankenbrowser.
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @11:47PM (3 children)
I would like the "slow down cowboy" thing to disappear. Commenting, navigating to another story, reading comments and then trying to comment may take me less than the limit, which is I think 60 seconds.
(Score: 3, Interesting) by The Mighty Buzzard on Wednesday January 09 2019, @12:49AM (2 children)
Sounds good until you realize it would leave folks able to spam the complete and utter hell out of every non-archived story without so much as a speed bump. It is a thing that's extended to subscribers though. Not because they're special but because at least the site got something useful out of it if they waste a bunch of staff time cleaning up after them.
My rights don't end where your fear begins.
(Score: 2) by maxwell demon on Wednesday January 09 2019, @06:54AM (1 child)
What about enacting the time limit only for three or more posts in a row? Spammers would still get blocked, but most normal users won't run into the restriction.
The logic could be almost the same as currently: Instead of denying a new post when there was one post in the last 60 seconds, you'd deny a new post when there were 2 posts in the last 120 seconds.
The Tao of math: The numbers you can count are not the real numbers.
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @11:25AM
Doable but that'd still require formkeys. I was thinking to yoink that logic out entirely for registered users.
My rights don't end where your fear begins.
(Score: 2) by Pino P on Wednesday January 09 2019, @12:41AM (5 children)
"Invalid form key" might happen if you click Reply and then wait several hours before submitting.
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @12:50AM (4 children)
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)
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
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)
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?
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @02:21PM
It could likely be removed entirely for registered users. I'll need some thought time on the ramifications.
My rights don't end where your fear begins.
(Score: 2) by GeminiDomino on Tuesday January 08 2019, @07:44PM
I got all of those, and whether or not the threading was indented or not seemed to be determined entirely at random on page load. I thought it was my uMatrix or cookie autodelete.
"We've been attacked by the intelligent, educated segment of our culture"
(Score: 4, Informative) by The Mighty Buzzard on Tuesday January 08 2019, @07:51PM (1 child)
Should be cleared up. Apache on fluorine had temporarily lost its mind but a bounce of the process seems to have cleared it up. My BOFH excuse is cosmic rays randomly flipping bits in ram until something useful shows up in the error_log.
My rights don't end where your fear begins.
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @07:57PM
+1 for the BOFH reference.
(Score: 0) by Anonymous Coward on Wednesday January 09 2019, @11:11AM (1 child)
It looked all washed out, grey, with bits missed?
It looked okay the next day.
I figured someone made a CSS fluckup.
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @11:28AM
The CSS includes get sent out as part of a "header" routine. It was shitting itself for reasons currently unknown. So was the "footer" call for that matter.
My rights don't end where your fear begins.
(Score: 2) by Subsentient on Tuesday January 08 2019, @10:07PM (1 child)
The site was seriously slow for weeks now, and suddenly it's back to a usable state. Thanks!
"It is no measure of health to be well adjusted to a profoundly sick society." -Jiddu Krishnamurti
(Score: 2) by The Mighty Buzzard on Tuesday January 08 2019, @11:48PM
I figured it would take a lot more testing, tweaking, retesting, and so on or I wouldn't have waited until I had a couple days free.
My rights don't end where your fear begins.