Board loading very slow

[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

[david63]

What could be the issue?

Many things but without a link to your board all anyone can do is make a guess.

[Exclusive]

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!

[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.

[Exclusive]

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?

I haven't faced spam issues for quite long.

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

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.

[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.

[Exclusive]

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.

Where can I check this?

[warmweer]

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

[Exclusive]

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?

[JoshyPHP]

Probably dmzx YouTube gallery, disable YouTube stats. Somebody ping dmzx to tell him to cache the stats in the database.

[Exclusive]

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.

[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.

[Exclusive]

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.

[Exclusive]

Bump...

[HiFiKabin]

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!