March 2024 Performance Issues

Important Trombone Chat information starts here.
Post Reply
User avatar
Matt K
Verified
Posts: 4240
Joined: Tue Mar 20, 2018 10:34 pm
Contact:

March 2024 Performance Issues

Post by Matt K »

Received some reports of sluggishness today. There was a memory leak in the database that I just fixed which should address the issue. Let me know here if anyone is sitll having issues and I'll take a closer look into it today.
mgladdish
Posts: 58
Joined: Sun Oct 10, 2021 4:08 am
Location: London, UK
Contact:

Re: March 2024 Performance Issues

Post by mgladdish »

I literally got a CloudFlare error when trying to view this thread :biggrin:

Also been having intermittent errors connecting to MySQL over the course of the day.
User avatar
bitbckt
Posts: 134
Joined: Wed Aug 19, 2020 11:41 am
Location: Maine

Re: March 2024 Performance Issues

Post by bitbckt »

Much improved, particularly jumping to the latest posts on longer threads. Thanks!
User avatar
ghmerrill
Posts: 946
Joined: Mon Apr 02, 2018 4:41 pm
Location: Central North Carolina

Re: March 2024 Performance Issues

Post by ghmerrill »

Some of the "issue" may not be with this site. I was having very sluggish network performance (via our supposedly 40M DSL line) this morning for about half an hour and then it improved. But I'm currently getting half the download speed that we're supposed to -- 25Mbps vs. 40Mbps. How local that is, I haven't looked into -- because life is too short.
Gary Merrill
Amati Oval Euph
1924 Buescher 3-valve Eb tuba
Schiller American Heritage 7B clone bass trombone
M/K nickel MV50 leadpipe
DE LB K/K8/110 Lexan
1947 Olds "Standard" trombone (Bach 12c)
User avatar
BGuttman
Posts: 6296
Joined: Thu Mar 22, 2018 7:19 am
Location: Cow Hampshire

Re: March 2024 Performance Issues

Post by BGuttman »

I had noticed a bunch of duplicate posts (more than normal) today. Probably because the posters experienced the delay and thought it had not posted.

Note that if you double post and I catch it, I'll remove one. If one of the posts has more comment I'll keep that one.
Bruce Guttman
Merrimack Valley Philharmonic Orchestra
"Almost Professional"
hyperbolica
Posts: 3158
Joined: Fri Mar 23, 2018 7:31 am

Re: March 2024 Performance Issues

Post by hyperbolica »

It was bad, then it improved, and now it's bad again. I think it's larger than just this site. There was a cable break of a major line in the middle east. That may be causing traffic to re-route and disrupting us here.
User avatar
ghmerrill
Posts: 946
Joined: Mon Apr 02, 2018 4:41 pm
Location: Central North Carolina

Re: March 2024 Performance Issues

Post by ghmerrill »

There appear to be jagged spikes in "bandwidth outages" and DNS server issues beginning this morning. The graphs are saw-toothed. Up and down, up and down, ...
Gary Merrill
Amati Oval Euph
1924 Buescher 3-valve Eb tuba
Schiller American Heritage 7B clone bass trombone
M/K nickel MV50 leadpipe
DE LB K/K8/110 Lexan
1947 Olds "Standard" trombone (Bach 12c)
Slidingmyway
Posts: 1
Joined: Wed Mar 06, 2024 6:16 pm

Re: March 2024 Performance Issues

Post by Slidingmyway »

BGuttman wrote: Thu Mar 07, 2024 8:37 am I had noticed a bunch of duplicate posts (more than normal) today. Probably because the posters experienced the delay and thought it had not posted.

Note that if you double post and I catch it, I'll remove one. If one of the posts has more comment I'll keep that one.
That happened to me. I accidentally posted the same thread 5 times. My apologies to whomever had to clean up my mess.
Posaunus
Posts: 3888
Joined: Fri Mar 23, 2018 9:54 pm
Location: California

Re: March 2024 Performance Issues

Post by Posaunus »

Response speed briefly improved this morning (I think). Now again very slow. :frown:
User avatar
EriKon
Posts: 298
Joined: Sun Apr 03, 2022 7:03 am
Location: Germany
Contact:

Re: March 2024 Performance Issues

Post by EriKon »

Yeah, takes quite long to load everything since one or two days. For me it's just on this page.
Posaunus
Posts: 3888
Joined: Fri Mar 23, 2018 9:54 pm
Location: California

Re: March 2024 Performance Issues

Post by Posaunus »

Just 5 minutes ago, Website speed magically improved. Almost immediate response! :good:

(Let's hope it remains so!)
User avatar
EriKon
Posts: 298
Joined: Sun Apr 03, 2022 7:03 am
Location: Germany
Contact:

Re: March 2024 Performance Issues

Post by EriKon »

Yes, over here as well!
User avatar
Matt K
Verified
Posts: 4240
Joined: Tue Mar 20, 2018 10:34 pm
Contact:

Re: March 2024 Performance Issues

Post by Matt K »

Hmmmm interesting. I have a family issue today that cropped up so I haven’t had a chance to look into it. I think the connection stuff is definitely partially to blame. It may not have been a memory leak but if the connections are slow then it’ll leave handles to the DB open which would look like a memory leak.

It’s still a little slow for me as I type. I’ll keep my eye on it as my family stuff hopefully resolves today and see if I can (ideally) permanently fix tomorrow if there are any issues that are fixable by me
User avatar
EriKon
Posts: 298
Joined: Sun Apr 03, 2022 7:03 am
Location: Germany
Contact:

Re: March 2024 Performance Issues

Post by EriKon »

Seems like it's not a constant thing over here. Sometimes it works super fast for a few minutes and then again it takes a minute to load everything (sometimes with error pop-up)
mgladdish
Posts: 58
Joined: Sun Oct 10, 2021 4:08 am
Location: London, UK
Contact:

Re: March 2024 Performance Issues

Post by mgladdish »

Yeah, still very bad. Just got this when loading a topic:

Image

If I can be any help on the tech side, give me a shout. Techie creds: https://www.linkedin.com/in/mgladdish/
Posaunus
Posts: 3888
Joined: Fri Mar 23, 2018 9:54 pm
Location: California

Re: March 2024 Performance Issues

Post by Posaunus »

STILL ... ... VERY ... ... SLOW

General Error
SQL ERROR [ mysqli ]

Lock wait timeout exceeded; try restarting transaction [1205]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Please notify the board administrator or webmaster: [email protected]
User avatar
slideandtraps
Posts: 14
Joined: Wed Dec 13, 2023 11:43 pm
Location: Des Moines, IA

Re: March 2024 Performance Issues

Post by slideandtraps »

Experienced above SQL error this evening and personal total posts dropped to 1
with "800%" and "300%" of total posted in other topics.
User avatar
Matt K
Verified
Posts: 4240
Joined: Tue Mar 20, 2018 10:34 pm
Contact:

Re: March 2024 Performance Issues

Post by Matt K »

Okay, think I found the culprit. Everything all good with my family too, one of my relatives had a minor surgery last night but all is good today. I'm going to keep my eye on it today and will need to put a more permanent fix in this weekend.
User avatar
EriKon
Posts: 298
Joined: Sun Apr 03, 2022 7:03 am
Location: Germany
Contact:

Re: March 2024 Performance Issues

Post by EriKon »

Seems to work fine now. Thanks Matt for taking care of that! Much appreciated!
User avatar
sacfxdx
Posts: 349
Joined: Wed Apr 11, 2018 4:25 pm
Location: North Georgia, US

Re: March 2024 Performance Issues

Post by sacfxdx »

Where's that AI when you need it? It should have fixed it automatically. I guess it's too busy faking nude pictures. :o

Good job Matt. Thanks for taking care of this.
Steve
User avatar
Matt K
Verified
Posts: 4240
Joined: Tue Mar 20, 2018 10:34 pm
Contact:

Re: March 2024 Performance Issues

Post by Matt K »

sacfxdx wrote: Fri Mar 08, 2024 8:34 am Where's that AI when you need it? It should have fixed it automatically. I guess it's too busy faking nude pictures. :o

Good job Matt. Thanks for taking care of this.
Welllllll about that. Turns out the script I’ve been using to capture spam, bots, and AI has became quite expensive computationally because of some automatic rules compounded with an enormous amount of AI generated garbage. The solution is actually not a big deal, just didn’t expect to have it come to a head this quickly. I was hoping to hold off until the next LTS of Ubuntu came out and switch over to that and fix a bunch of stuff at the same time (next LTS drops in April)
User avatar
ghmerrill
Posts: 946
Joined: Mon Apr 02, 2018 4:41 pm
Location: Central North Carolina

Re: March 2024 Performance Issues

Post by ghmerrill »

Matt K wrote: Fri Mar 08, 2024 9:04 am ... enormous amount of AI generated garbage.
Dumb AI. :( Well (in virtue of my 10 years in a previous life as a commercial compiler writer), It takes a very well designed automated code generator (and read that as "often very expensive") to generate optimal code or anything approximating it. And if you're doing some or all of that on the fly at run time, then there's an added efficiency cost as well (in optimizing the optimizer). Other than that, you can only do your best with what you can get. :good:
Gary Merrill
Amati Oval Euph
1924 Buescher 3-valve Eb tuba
Schiller American Heritage 7B clone bass trombone
M/K nickel MV50 leadpipe
DE LB K/K8/110 Lexan
1947 Olds "Standard" trombone (Bach 12c)
Posaunus
Posts: 3888
Joined: Fri Mar 23, 2018 9:54 pm
Location: California

Re: March 2024 Performance Issues

Post by Posaunus »

Matt,

All good this morning.

Thanks for your efforts on our behalf. :good:
User avatar
Matt K
Verified
Posts: 4240
Joined: Tue Mar 20, 2018 10:34 pm
Contact:

Re: March 2024 Performance Issues

Post by Matt K »

I think I have the spam busting script back in place more efficiently now. It just ran and spike performance for a few seconds but it shouldn't be much more noticeable than typical usage and runs every few minutes, but only if there have been posts. LMK if anyone has issues tonight/into tomorrow.
User avatar
ithinknot
Posts: 1107
Joined: Fri Jul 24, 2020 3:40 pm

Re: March 2024 Performance Issues

Post by ithinknot »

Have you noticed that user post counts are displaying weird numbers? Sometimes it's just a bit wrong, in other cases longtime users are showing as 1...

At the time of writing this, mine says 1010 next to a post or when you open my profile, but if you click through to 'Search user's posts' it finds all 1173.

Must be indicative of something.
User avatar
Matt K
Verified
Posts: 4240
Joined: Tue Mar 20, 2018 10:34 pm
Contact:

Re: March 2024 Performance Issues

Post by Matt K »

I reset one of the sites indexes the other day which has the side effect of recalculating the number of posts. I’m not sure why it thinks you have fewer posts than you do, unless the search results show duplicates for some reason
User avatar
harrisonreed
Posts: 5165
Joined: Fri Aug 17, 2018 12:18 pm
Location: Fort Riley, Kansas
Contact:

Re: March 2024 Performance Issues

Post by harrisonreed »

It might be counting quoted snippets as posts.
User avatar
ithinknot
Posts: 1107
Joined: Fri Jul 24, 2020 3:40 pm

Re: March 2024 Performance Issues

Post by ithinknot »

harrisonreed wrote: Mon Mar 11, 2024 6:47 am It might be counting quoted snippets as posts.
Nah, it's just nonsense in some cases.

To pick a couple of posters in this thread:
memberlist.php?mode=viewprofile&u=9927
search.php?author_id=9927&sr=posts
56 vs 152

memberlist.php?mode=viewprofile&u=13350
search.php?author_id=13350&sr=posts
12 vs 32

Obviously this doesn't particularly matter in use; I'm just bringing it up in case it's diagnostically significant...
Post Reply

Return to “News & Announcements”