March 2024 Performance Issues
- Matt K
- Verified
- Posts: 3955
- Joined: Tue Mar 20, 2018 10:34 pm
- Contact:
March 2024 Performance Issues
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.
-
- Posts: 26
- Joined: Sun Oct 10, 2021 4:08 am
- Location: London, UK
- Contact:
Re: March 2024 Performance Issues
I literally got a CloudFlare error when trying to view this thread
Also been having intermittent errors connecting to MySQL over the course of the day.
![Big Grin! :biggrin:](./images/smilies/biggrin.gif)
Also been having intermittent errors connecting to MySQL over the course of the day.
- bitbckt
- Posts: 83
- Joined: Wed Aug 19, 2020 11:41 am
- Location: Maine
Re: March 2024 Performance Issues
Much improved, particularly jumping to the latest posts on longer threads. Thanks!
- ghmerrill
- Posts: 584
- Joined: Mon Apr 02, 2018 4:41 pm
- Location: Central North Carolina
Re: March 2024 Performance Issues
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
Wessex EEb tuba
Mack Brass Compensating Euph
Amati Oval Euph
1924 Buescher 3-valve Eb tuba
Schiller American Heritage 7B clone bass trombone
DE LB K/K9/112 Lexan, Brass Ark MV50R
1947 Olds "Standard" trombone (Bach 12c)
Wessex EEb tuba
Mack Brass Compensating Euph
Amati Oval Euph
1924 Buescher 3-valve Eb tuba
Schiller American Heritage 7B clone bass trombone
DE LB K/K9/112 Lexan, Brass Ark MV50R
1947 Olds "Standard" trombone (Bach 12c)
- BGuttman
- Posts: 5967
- Joined: Thu Mar 22, 2018 7:19 am
- Location: Cow Hampshire
Re: March 2024 Performance Issues
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.
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"
Merrimack Valley Philharmonic Orchestra
"Almost Professional"
-
- Posts: 2849
- Joined: Fri Mar 23, 2018 7:31 am
Re: March 2024 Performance Issues
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.
- ghmerrill
- Posts: 584
- Joined: Mon Apr 02, 2018 4:41 pm
- Location: Central North Carolina
Re: March 2024 Performance Issues
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
Wessex EEb tuba
Mack Brass Compensating Euph
Amati Oval Euph
1924 Buescher 3-valve Eb tuba
Schiller American Heritage 7B clone bass trombone
DE LB K/K9/112 Lexan, Brass Ark MV50R
1947 Olds "Standard" trombone (Bach 12c)
Wessex EEb tuba
Mack Brass Compensating Euph
Amati Oval Euph
1924 Buescher 3-valve Eb tuba
Schiller American Heritage 7B clone bass trombone
DE LB K/K9/112 Lexan, Brass Ark MV50R
1947 Olds "Standard" trombone (Bach 12c)
-
- Posts: 1
- Joined: Wed Mar 06, 2024 6:16 pm
Re: March 2024 Performance Issues
That happened to me. I accidentally posted the same thread 5 times. My apologies to whomever had to clean up my mess.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.
-
- Posts: 3486
- Joined: Fri Mar 23, 2018 9:54 pm
- Location: California
Re: March 2024 Performance Issues
Response speed briefly improved this morning (I think). Now again very slow. ![Frown :frown:](./images/smilies/frown.gif)
![Frown :frown:](./images/smilies/frown.gif)
- EriKon
- Posts: 248
- Joined: Sun Apr 03, 2022 7:03 am
- Location: Germany
- Contact:
Re: March 2024 Performance Issues
Yeah, takes quite long to load everything since one or two days. For me it's just on this page.
-
- Posts: 3486
- Joined: Fri Mar 23, 2018 9:54 pm
- Location: California
Re: March 2024 Performance Issues
Just 5 minutes ago, Website speed magically improved. Almost immediate response!
(Let's hope it remains so!)
![Good :good:](./images/smilies/good.gif)
(Let's hope it remains so!)
- EriKon
- Posts: 248
- Joined: Sun Apr 03, 2022 7:03 am
- Location: Germany
- Contact:
Re: March 2024 Performance Issues
Yes, over here as well!
- Matt K
- Verified
- Posts: 3955
- Joined: Tue Mar 20, 2018 10:34 pm
- Contact:
Re: March 2024 Performance Issues
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
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
- EriKon
- Posts: 248
- Joined: Sun Apr 03, 2022 7:03 am
- Location: Germany
- Contact:
Re: March 2024 Performance Issues
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)
-
- Posts: 26
- Joined: Sun Oct 10, 2021 4:08 am
- Location: London, UK
- Contact:
Re: March 2024 Performance Issues
Yeah, still very bad. Just got this when loading a topic:
![Image](https://i.postimg.cc/qMxhGQ98/Screenshot-2024-03-08-at-07-24-35.png)
If I can be any help on the tech side, give me a shout. Techie creds: https://www.linkedin.com/in/mgladdish/
![Image](https://i.postimg.cc/qMxhGQ98/Screenshot-2024-03-08-at-07-24-35.png)
If I can be any help on the tech side, give me a shout. Techie creds: https://www.linkedin.com/in/mgladdish/
-
- Posts: 3486
- Joined: Fri Mar 23, 2018 9:54 pm
- Location: California
Re: March 2024 Performance Issues
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]
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]
- slideandtraps
- Posts: 3
- Joined: Wed Dec 13, 2023 11:43 pm
- Location: Phoenix, AZ
Re: March 2024 Performance Issues
Experienced above SQL error this evening and personal total posts dropped to 1
with "800%" and "300%" of total posted in other topics.
with "800%" and "300%" of total posted in other topics.
- Matt K
- Verified
- Posts: 3955
- Joined: Tue Mar 20, 2018 10:34 pm
- Contact:
Re: March 2024 Performance Issues
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.
- EriKon
- Posts: 248
- Joined: Sun Apr 03, 2022 7:03 am
- Location: Germany
- Contact:
Re: March 2024 Performance Issues
Seems to work fine now. Thanks Matt for taking care of that! Much appreciated!
- sacfxdx
- Posts: 326
- Joined: Wed Apr 11, 2018 4:25 pm
- Location: North Georgia, US
Re: March 2024 Performance Issues
Where's that AI when you need it? It should have fixed it automatically. I guess it's too busy faking nude pictures.
Good job Matt. Thanks for taking care of this.
![Surprised :o](./images/smilies/icon_e_surprised.gif)
Good job Matt. Thanks for taking care of this.
Steve
- Matt K
- Verified
- Posts: 3955
- Joined: Tue Mar 20, 2018 10:34 pm
- Contact:
Re: March 2024 Performance Issues
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)
- ghmerrill
- Posts: 584
- Joined: Mon Apr 02, 2018 4:41 pm
- Location: Central North Carolina
Re: March 2024 Performance Issues
Dumb AI.
![Sad :(](./images/smilies/icon_e_sad.gif)
![Good :good:](./images/smilies/good.gif)
Gary Merrill
Wessex EEb tuba
Mack Brass Compensating Euph
Amati Oval Euph
1924 Buescher 3-valve Eb tuba
Schiller American Heritage 7B clone bass trombone
DE LB K/K9/112 Lexan, Brass Ark MV50R
1947 Olds "Standard" trombone (Bach 12c)
Wessex EEb tuba
Mack Brass Compensating Euph
Amati Oval Euph
1924 Buescher 3-valve Eb tuba
Schiller American Heritage 7B clone bass trombone
DE LB K/K9/112 Lexan, Brass Ark MV50R
1947 Olds "Standard" trombone (Bach 12c)
-
- Posts: 3486
- Joined: Fri Mar 23, 2018 9:54 pm
- Location: California
Re: March 2024 Performance Issues
Matt,
All good this morning.
Thanks for your efforts on our behalf.![Good :good:](./images/smilies/good.gif)
All good this morning.
Thanks for your efforts on our behalf.
![Good :good:](./images/smilies/good.gif)
- Matt K
- Verified
- Posts: 3955
- Joined: Tue Mar 20, 2018 10:34 pm
- Contact:
Re: March 2024 Performance Issues
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.
- ithinknot
- Posts: 1054
- Joined: Fri Jul 24, 2020 3:40 pm
Re: March 2024 Performance Issues
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.
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.
- Matt K
- Verified
- Posts: 3955
- Joined: Tue Mar 20, 2018 10:34 pm
- Contact:
Re: March 2024 Performance Issues
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
- harrisonreed
- Posts: 4607
- Joined: Fri Aug 17, 2018 12:18 pm
- Location: Fort Riley, Kansas
- Contact:
Re: March 2024 Performance Issues
It might be counting quoted snippets as posts.
- ithinknot
- Posts: 1054
- Joined: Fri Jul 24, 2020 3:40 pm
Re: March 2024 Performance Issues
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...