Board loading very slow

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
User avatar
Exclusive
Registered User
Posts: 619
Joined: Mon Jun 25, 2018 1:33 pm

Board loading very slow

Post by Exclusive »

My board loads very slow, even after moving to a new hos. What could be the issue?

Below is the slow log

Code: Select all

Last entry is this one, around 30 seconds ago:

[20-Jan-2021 21:06:13] [pool vxrprftxex] pid 31825
script_filename = /home/534462.cloudwaysapps.com/vxrprftxex/public_html/index.php
[0x00007fd36221eaa0] mysqli_query() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/phpbb/db/driver/mysqli.php:191
[0x00007fd36221e9f0] sql_query() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/phpbb/db/driver/mysql_base.php:45
[0x00007fd36221e940] _sql_query_limit() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/phpbb/db/driver/driver.php:270
[0x00007fd36221e8a0] sql_query_limit() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/phpbb/db/driver/factory.php:321
[0x00007fd36221e800] sql_query_limit() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/ext/dmzx/youtubegallery/event/listener.php:226
[0x00007fd36221e690] index_modify_page_title() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/vendor/symfony/event-dispatcher/EventDispatcher.php:184
[0x00007fd36221e600] call_user_func() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/vendor/symfony/event-dispatcher/EventDispatcher.php:184
[0x00007fd36221e550] doDispatch() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/vendor/symfony/event-dispatcher/EventDispatcher.php:46
[0x00007fd36221e4b0] dispatch() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/phpbb/event/dispatcher.php:62
[0x00007fd36221e410] dispatch() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/phpbb/event/dispatcher.php:46
[0x00007fd36221e380] trigger_event() /home/534462.cloudwaysapps.com/vxrprftxex/public_html/index.php:237
Edited: My board's link
Last edited by Exclusive on Wed Jan 20, 2021 9:25 pm, edited 1 time in total.
Use Search Button to get Instant Results | Follow Forum Rules
Avoid Spams in the forum to prevent banning the offending account. | ⟿ Visit My Awesome phpBB Forum! ⬳

Best Web Hosting with 99.9% Uptime! | ✔ Buy Cheap Domain Names
User avatar
david63
Registered User
Posts: 19036
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: Board loading very slow

Post by david63 »

Exclusive wrote:
Wed Jan 20, 2021 9:08 pm
What could be the issue?
Many things but without a link to your board all anyone can do is make a guess.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
User avatar
Exclusive
Registered User
Posts: 619
Joined: Mon Jun 25, 2018 1:33 pm

Re: Board loading very slow

Post by Exclusive »

david63 wrote:
Wed Jan 20, 2021 9:22 pm
Exclusive wrote:
Wed Jan 20, 2021 9:08 pm
What could be the issue?
Many things but without a link to your board all anyone can do is make a guess.
I have added a link to my board on the first post!
Use Search Button to get Instant Results | Follow Forum Rules
Avoid Spams in the forum to prevent banning the offending account. | ⟿ Visit My Awesome phpBB Forum! ⬳

Best Web Hosting with 99.9% Uptime! | ✔ Buy Cheap Domain Names
User avatar
david63
Registered User
Posts: 19036
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: Board loading very slow

Post by david63 »

Just at first glance your board is quite image intensive, you have a lot of forums on the opening page, there is a lot of js running on the board and the board has had the cache purged almost 3000 times.

Also the fact that you have over 15000 members and only 2800 posts looks suspicious. Have you been having a spam problem and been blocking IP and/or email addresses?

Another thing is that you appear to be running with Cloudflare which I believe if incorrectly configured can slow a board down - but I am not a Cloudflare expert.

You need to strip your board down and rebuild it one bit at a time to see where the problem lies - starting with the default prosilver style.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
User avatar
Exclusive
Registered User
Posts: 619
Joined: Mon Jun 25, 2018 1:33 pm

Re: Board loading very slow

Post by Exclusive »

david63 wrote:
Wed Jan 20, 2021 9:40 pm
Just at first glance your board is quite image intensive, you have a lot of forums on the opening page, there is a lot of js running on the board and the board has had the cache purged almost 3000 times.
david63 wrote:
Wed Jan 20, 2021 9:40 pm
Also the fact that you have over 15000 members and only 2800 posts looks suspicious. Have you been having a spam problem and been blocking IP and/or email addresses?
I haven't faced spam issues for quite long.
david63 wrote:
Wed Jan 20, 2021 9:40 pm
Another thing is that you appear to be running with Cloudflare which I believe if incorrectly configured can slow a board down - but I am not a Cloudflare expert.
I don't think there is an issue with my Cloudflare's configuration
david63 wrote:
Wed Jan 20, 2021 9:40 pm
You need to strip your board down and rebuild it one bit at a time to see where the problem lies - starting with the default prosilver style.
I think the issue could be from MySQL i have been having SQL issues.
Use Search Button to get Instant Results | Follow Forum Rules
Avoid Spams in the forum to prevent banning the offending account. | ⟿ Visit My Awesome phpBB Forum! ⬳

Best Web Hosting with 99.9% Uptime! | ✔ Buy Cheap Domain Names
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52298
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Board loading very slow

Post by Brf »

The debug at the bottom is showing 4.8 seconds to load the index.php. I assuming you should see which queries are slowing that down.
User avatar
Exclusive
Registered User
Posts: 619
Joined: Mon Jun 25, 2018 1:33 pm

Re: Board loading very slow

Post by Exclusive »

Brf wrote:
Wed Jan 20, 2021 10:04 pm
The debug at the bottom is showing 4.8 seconds to load the index.php. I assuming you should see which queries are slowing that down.
The debug load time is not specific, it fluctuates.
Brf wrote:
Wed Jan 20, 2021 10:04 pm
Where can I check this?
Use Search Button to get Instant Results | Follow Forum Rules
Avoid Spams in the forum to prevent banning the offending account. | ⟿ Visit My Awesome phpBB Forum! ⬳

Best Web Hosting with 99.9% Uptime! | ✔ Buy Cheap Domain Names
User avatar
warmweer
Jr. Extension Validator
Posts: 6487
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Board loading very slow

Post by warmweer »

Exclusive wrote:
Wed Jan 20, 2021 10:15 pm
Brf wrote:
Wed Jan 20, 2021 10:04 pm
The debug at the bottom is showing 4.8 seconds to load the index.php. I assuming you should see which queries are slowing that down.
The debug load time is not specific, it fluctuates.
About an hour ago it was 14 something seconds and I looked again just now; page took 11 seconds to load. That really too much for the limited number of users you have (and that was with 18 guests) and 31 queries - it should load almost instantaneously.
Just compared to my board: 54 user online, 32 queries, load time 3.4 seconds
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
User avatar
Exclusive
Registered User
Posts: 619
Joined: Mon Jun 25, 2018 1:33 pm

Re: Board loading very slow

Post by Exclusive »

warmweer wrote:
Wed Jan 20, 2021 11:25 pm
About an hour ago it was 14 something seconds and I looked again just now; page took 11 seconds to load. That really too much for the limited number of users you have (and that was with 18 guests) and 31 queries - it should load almost instantaneously.
Just compared to my board: 54 user online, 32 queries, load time 3.4 seconds
So how do I fix this?
Use Search Button to get Instant Results | Follow Forum Rules
Avoid Spams in the forum to prevent banning the offending account. | ⟿ Visit My Awesome phpBB Forum! ⬳

Best Web Hosting with 99.9% Uptime! | ✔ Buy Cheap Domain Names
User avatar
JoshyPHP
Code Contributor
Posts: 1209
Joined: Mon Jul 11, 2011 12:28 am

Re: Board loading very slow

Post by JoshyPHP »

Probably dmzx YouTube gallery, disable YouTube stats. Somebody ping dmzx to tell him to cache the stats in the database.
I wrote the thing that does BBCodes in 3.2+.
User avatar
Exclusive
Registered User
Posts: 619
Joined: Mon Jun 25, 2018 1:33 pm

Re: Board loading very slow

Post by Exclusive »

JoshyPHP wrote:
Thu Jan 21, 2021 3:20 am
Probably dmzx YouTube gallery, disable YouTube stats. Somebody ping dmzx to tell him to cache the stats in the database.
I just disabled the extension and yet my board still loads slow.
Use Search Button to get Instant Results | Follow Forum Rules
Avoid Spams in the forum to prevent banning the offending account. | ⟿ Visit My Awesome phpBB Forum! ⬳

Best Web Hosting with 99.9% Uptime! | ✔ Buy Cheap Domain Names
User avatar
JoshyPHP
Code Contributor
Posts: 1209
Joined: Mon Jul 11, 2011 12:28 am

Re: Board loading very slow

Post by JoshyPHP »

Then actually disable all extensions for real (that YouTube extension is still active) and see how that works out. Also, do post the SRT template because you've given no actionable information whatsoever.
I wrote the thing that does BBCodes in 3.2+.
User avatar
Exclusive
Registered User
Posts: 619
Joined: Mon Jun 25, 2018 1:33 pm

Re: Board loading very slow

Post by Exclusive »

JoshyPHP wrote:
Thu Jan 21, 2021 12:57 pm
Then actually disable all extensions for real (that YouTube extension is still active) and see how that works out. Also, do post the SRT template because you've given no actionable information whatsoever.
But my ACP loads very fast.
Use Search Button to get Instant Results | Follow Forum Rules
Avoid Spams in the forum to prevent banning the offending account. | ⟿ Visit My Awesome phpBB Forum! ⬳

Best Web Hosting with 99.9% Uptime! | ✔ Buy Cheap Domain Names
User avatar
Exclusive
Registered User
Posts: 619
Joined: Mon Jun 25, 2018 1:33 pm

Re: Board loading very slow

Post by Exclusive »

Bump...
Use Search Button to get Instant Results | Follow Forum Rules
Avoid Spams in the forum to prevent banning the offending account. | ⟿ Visit My Awesome phpBB Forum! ⬳

Best Web Hosting with 99.9% Uptime! | ✔ Buy Cheap Domain Names
User avatar
HiFiKabin
Community Team Member
Community Team Member
Posts: 5250
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: Board loading very slow

Post by HiFiKabin »

Exclusive wrote:
Thu Jan 21, 2021 10:58 pm
Please keep in mind that we have a six hour bumping rule. All team members and community members here are volunteers, so we ask you to wait at least six hours before bumping your topic or, if no-one has replied to your last post, edit your last post. Thanks!
Post Reply

Return to “[3.2.x] Support Forum”