Slow forum
Re: Slow forum
Tank had issues with the database before - did you check that @joedf
Recommends AHK Studio
Re: Slow forum
Mmmh, feels as if bot throttling is enabled by default.
Re: Slow forum
I am not super clear on what scripts are running, but... from my last communication with tank, we both think it might a rogue php script or something...
I tried disabling the obvious anti-spam/bot scripts I could find but that didn't work...
If nothing works, we might have to start off with a fresh copy of phpbb, or perhaps an update... not sure.
No fun, since this is just not viable. Forums are unusable like this... :/
I tried disabling the obvious anti-spam/bot scripts I could find but that didn't work...
If nothing works, we might have to start off with a fresh copy of phpbb, or perhaps an update... not sure.
No fun, since this is just not viable. Forums are unusable like this... :/
Windows 10 x64 Professional, Intel i5-8500, NVIDIA GTX 1060 6GB, 2x16GB Kingston FURY Beast - DDR4 3200 MHz | [About Me] | [About the AHK Foundation] | [Courses on AutoHotkey]
[ASPDM - StdLib Distribution] | [Qonsole - Quake-like console emulator] | [LibCon - Autohotkey Console Library]
Re: Slow forum
The last time this happened @tank fixed it by sorting out the database.
My scripts:-
XRef - Produces Cross Reference lists for scripts
ReClip - A Text Reformatting and Clip Management utility
ScriptGuard - Protects Compiled Scripts from Decompilation
I also maintain Ahk2Exe
XRef - Produces Cross Reference lists for scripts
ReClip - A Text Reformatting and Clip Management utility
ScriptGuard - Protects Compiled Scripts from Decompilation
I also maintain Ahk2Exe
Re: Slow forum
I can’t imagine that we need to start all over or an update to fix this. I’d offer to help though I have no access and no knowledge of the current system setup.
Re: Slow forum
I've managed to narrow it down to this specific line:
https://github.com/phpbb/phpbb/blob/c2c5c20c319d397948218b4c342fb146bf15040b/phpBB/common.php#L115
using the following simple snippet
I've determined that this line cause a rather consistent 20 second lag.
I added $phpbb_container_builder->without_cache(); and the increased to 40.002 seconds.
The lag is consistently 20 seconds for me whether it's my speedy internet at home or somewhat slower network at work...
TLDR: This might be caused by parameters or throttling related to the DB.
https://github.com/phpbb/phpbb/blob/c2c5c20c319d397948218b4c342fb146bf15040b/phpBB/common.php#L115
using the following simple snippet
Code: Select all
$start_time = microtime(TRUE);
// line to benchmark here ...
$end_time = microtime(TRUE);
echo $end_time - $start_time;
I added $phpbb_container_builder->without_cache(); and the increased to 40.002 seconds.
The lag is consistently 20 seconds for me whether it's my speedy internet at home or somewhat slower network at work...
TLDR: This might be caused by parameters or throttling related to the DB.
Windows 10 x64 Professional, Intel i5-8500, NVIDIA GTX 1060 6GB, 2x16GB Kingston FURY Beast - DDR4 3200 MHz | [About Me] | [About the AHK Foundation] | [Courses on AutoHotkey]
[ASPDM - StdLib Distribution] | [Qonsole - Quake-like console emulator] | [LibCon - Autohotkey Console Library]
Re: Slow forum
Update: Pretty certain this is mysql related. Manually connecting to the DB using shell access with
$ mysql -uUSERNAME -pPASS -hHOST [--port=Port] DB_Name
Leads to an 18-20 second lag till the prompt shows:
mysql>
$ mysql -uUSERNAME -pPASS -hHOST [--port=Port] DB_Name
Leads to an 18-20 second lag till the prompt shows:
mysql>
Windows 10 x64 Professional, Intel i5-8500, NVIDIA GTX 1060 6GB, 2x16GB Kingston FURY Beast - DDR4 3200 MHz | [About Me] | [About the AHK Foundation] | [Courses on AutoHotkey]
[ASPDM - StdLib Distribution] | [Qonsole - Quake-like console emulator] | [LibCon - Autohotkey Console Library]
Re: Slow forum
Update: talked to tank. so not exactly a DB issue, possibly some networking issue. We are narrowing the problem down.
Sorry for any inconvenience. Trying to keep people up to date.
Sorry for any inconvenience. Trying to keep people up to date.
Windows 10 x64 Professional, Intel i5-8500, NVIDIA GTX 1060 6GB, 2x16GB Kingston FURY Beast - DDR4 3200 MHz | [About Me] | [About the AHK Foundation] | [Courses on AutoHotkey]
[ASPDM - StdLib Distribution] | [Qonsole - Quake-like console emulator] | [LibCon - Autohotkey Console Library]
Re: Slow forum
Good man, @joedf!
My scripts:-
XRef - Produces Cross Reference lists for scripts
ReClip - A Text Reformatting and Clip Management utility
ScriptGuard - Protects Compiled Scripts from Decompilation
I also maintain Ahk2Exe
XRef - Produces Cross Reference lists for scripts
ReClip - A Text Reformatting and Clip Management utility
ScriptGuard - Protects Compiled Scripts from Decompilation
I also maintain Ahk2Exe
Re: Slow forum
Thanks for the updates and good investigation! It is much appreciated. Do you get any useful output by appending the --verbose flag? Where is the database hosted?
Re: Slow forum
No bueno. no error messages. The black out possibly caused some kind of net interface issue. :/
Windows 10 x64 Professional, Intel i5-8500, NVIDIA GTX 1060 6GB, 2x16GB Kingston FURY Beast - DDR4 3200 MHz | [About Me] | [About the AHK Foundation] | [Courses on AutoHotkey]
[ASPDM - StdLib Distribution] | [Qonsole - Quake-like console emulator] | [LibCon - Autohotkey Console Library]
Re: Slow forum
What I see in working through long lists of approval requests multiple times in recent days is that apparently new users (or with low post count) apparently don't realize that their post or request already got through. So they end up double- or triple-posting and/or requesting approval 5 to 15 times until they seem to be able to see one of their posts.
"Normal" users don't seem to be affected. Not sure, if this is of any use for trouble-shooting... might not be a reason for, but another consequence of the current problems.
"Normal" users don't seem to be affected. Not sure, if this is of any use for trouble-shooting... might not be a reason for, but another consequence of the current problems.
Re: Slow forum
Silly question but what about rebooting both the app and database servers?
Re: Slow forum
@gregster
Very true and annoying. :s
@kczx3
We have tried that with all servers. Talked with tank, we took this as an opportunity to upgrade the server with more memory and disk space.
Very true and annoying. :s
@kczx3
We have tried that with all servers. Talked with tank, we took this as an opportunity to upgrade the server with more memory and disk space.
Windows 10 x64 Professional, Intel i5-8500, NVIDIA GTX 1060 6GB, 2x16GB Kingston FURY Beast - DDR4 3200 MHz | [About Me] | [About the AHK Foundation] | [Courses on AutoHotkey]
[ASPDM - StdLib Distribution] | [Qonsole - Quake-like console emulator] | [LibCon - Autohotkey Console Library]
Re: Slow forum
I just went to www.hardenize.com and got this report for www.autohotkey.com (also tried www.autohotkey.com/boards, same report).
(I'm trying to attach a 17kb screenshot, but it's not working. I'll try again. EDIT: Attachments will not load. RE-EDIT: Oops! It just took four minutes to load, but it did load.)
(I'm trying to attach a 17kb screenshot, but it's not working. I'll try again. EDIT: Attachments will not load. RE-EDIT: Oops! It just took four minutes to load, but it did load.)
HTTPS
Web sites need to use encryption to help their visitors know they're in the right place, as well as provide confidentiality and content integrity. Sites that don't support HTTPS may expose sensitive data and have their pages modified and subverted.
There are issues with this site's HTTPS configuration.
For all sites VERY IMPORTANT medium EFFORT
Re: Slow forum
I don’t think https has anything to do with the slowness
Re: Slow forum
There was a MySql general error 2002 around 3 hours ago. There's 75 answers to that thread for pleasurable reading. Disk space is a common culprit.
The answer to this thread has a some clues if there were ever an IPV6 issue- it's most likely something to do with MySql- here's a typical thread which doesn't make for much light reading either. Good luck!
The answer to this thread has a some clues if there were ever an IPV6 issue- it's most likely something to do with MySql- here's a typical thread which doesn't make for much light reading either. Good luck!
itros "ylbbub eht tuO kaerB" a ni kcuts m'I pleH
Re: Slow forum
Thanks lmstearn, We've already tried and checked these. We think part the problem might have been on DigitalOcean's end.
We plan on migrating datacenters.
We plan on migrating datacenters.
Windows 10 x64 Professional, Intel i5-8500, NVIDIA GTX 1060 6GB, 2x16GB Kingston FURY Beast - DDR4 3200 MHz | [About Me] | [About the AHK Foundation] | [Courses on AutoHotkey]
[ASPDM - StdLib Distribution] | [Qonsole - Quake-like console emulator] | [LibCon - Autohotkey Console Library]
Re: Slow forum
Obviously, this is in your guys' hands. And maybe there's info you have that we don't. But migrating datacenters seems like a pretty ballsy move in hopes that it fixes this ghost of a problem. Please make sure to communicate any downtime's associated with this.
Who is online
Users browsing this forum: No registered users and 18 guests