Forum loading very slowly starting around 6/2/23 or so
- Thread starter Ravenpoe
- Start date
Yep. Been a few times I'll click on a link and it takes forever to load.
Yes I also noticed it Thu. I just assumed @GasBandit was biting the bullet and running that prune job regardless.
—Patrick
—Patrick
GasBandit
Staff member
It's not me this time, and I've noticed it too. I'm having a hell of a time tracking it down, but I'd bet dollars to donuts that it's a SQL issue. Every aspect of the site that doesn't require SQL database access is quick and snappy (CPanel/WHM for example) but the forum itself will have fits and spurts of working well then working shitty.
My knowledge of MySQL is extremely rudimentary. I'm having absolutely no luck figuring out what the problem is.
My knowledge of MySQL is extremely rudimentary. I'm having absolutely no luck figuring out what the problem is.
GasBandit
Staff member
Finally found how to do a DB repair. I don't know if that will do anything, just throwing shit against the wall to see what sticks. If I notice it being slow still I'll keep flailing around trying to find a button that does something.
I swear to god I feel like Mr. Fantastic in here sometimes.
I swear to god I feel like Mr. Fantastic in here sometimes.
GasBandit
Staff member
Well the bad news is that doesn't seem to have fixed it. But the slightly less bad news is, now that I know where to look, I can definitely confirm that the slowness coincides with a massive CPU spike usage in... oh shit, either it's MySQL or PHP, I should have been looking closer.
Ah hell, still fiddling
Ah hell, still fiddling
GasBandit
Staff member
I don't think it has. That vulnerability relies on a port being open to something besides localhost, which would deviate from the default. The only non-default settings we have in our php-fpm seems to be actually special additions disabling most of the commands that would be affected by that vulnerability anyway.
I have twice now gotten hangs that ended in a blank page with “could not establish a secure connection to the server” and “The server stopped responding.”
—Patrick
GasBandit
Staff member
Well to be fair, that's a completely different problem.
I tried to edit my above post in order to change it to "multiple times" but two consecutive attempts to edit the post would just stall and time out.
--Patrick
GasBandit
Staff member
Hmm, I have limited time and ability to test and troubleshoot this morning, but just reading around the threads and replying, I haven't experienced that... makes me think it might not be on the server end.
The majority of my current (i.e., since Sun eve) issues have been almost exclusively on mobile, so that may be part of it as well.
Desktop access seems to be no problem, just mobile. But the mobile interface has also had so many other issues with formatting, with the text editor, with plug-ins, etc. so I suppose it shouldn't be that surprising.
--Patrick
Desktop access seems to be no problem, just mobile. But the mobile interface has also had so many other issues with formatting, with the text editor, with plug-ins, etc. so I suppose it shouldn't be that surprising.
--Patrick
GasBandit
Staff member
Given that the issues are new, I don't think our version of XF is to blame here for that, either.
If the site is on a server with other sites, it could be some other site on the farm is getting DDOSed. This is common on sites like say, GoDaddy, where there might be hundreds and hundreds of sites on one server. If the traffic isn't coming directly to you, you'd never know the server is under load unless you work at the ISP.