Previous Thread
Next Thread
Print Thread
Hop To
how to check forum for slow posting
#263527 02/25/2020 3:17 PM
Joined: Dec 2003
Posts: 6,091
Likes: 14
Ruben Online Yawn OP
OP Online Yawn
Joined: Dec 2003
Posts: 6,091
Likes: 14
Using ver 7.7.3.
On shared hosting with Inmotionhosting.

I found that most pages complete display fairly quick. Even searches

Except for posting reply's and topics which are almost at the point of script timeout.
I have turned off indexing unreadposts.
I also have variables set at 3500

How can I go about diagnosing this issue?
What should I check first.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: how to check forum for slow posting
Ruben #263529 02/25/2020 3:30 PM
Joined: Apr 2004
Posts: 1,652
Likes: 33
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,652
Likes: 33
When was the last time you optimized your tables?

What size is your DB? What version of PHP? Is this issue 24/7 or only during peak times?


If your DB is large, you may have outgrown the resources of what your shared hosting provides.
For example, one of my larger UBBT sites DB is about 1.5GB. Its hosted through Bluehost on their "Professional" shared hosting plans. But if I were to switch my large forums to their entry-level/basic plan, I would be having the same issues you describe. Why? Because entry-level hosting packages tend to pack more accounts per server, which leads to less resources per account.


For example:

BLUEHOST shared hosting
BASIC (Standard Performance) vs PRO (fewer accounts per server @ High Performance)
https://www.bluehost.com/hosting/shared

STABLEHOST shared hosting
STARTER (500 accts per sever @ 1 Full CPU Core) vs PLATINUM (50 accts per sever @ 2 Full CPU Core)
https://www.stablehost.com/web-hosting.php

Last edited by isaac; 02/25/2020 3:38 PM. Reason: added links

Current developer of UBB.threads PHP Forum Software // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: how to check forum for slow posting
Ruben #263530 02/25/2020 3:54 PM
Joined: Dec 2003
Posts: 6,091
Likes: 14
Ruben Online Yawn OP
OP Online Yawn
Joined: Dec 2003
Posts: 6,091
Likes: 14
To be honest I have not optimized the tables in two months.
I could try again. Will do now
As far as when, it seems to be always.

Yes the db is somewhat large and a lot of visitors but few posts. 728.4MB
PHP is 7.2.24

The odd part is everything runs quick including searches just posting topics or replies are slow.
Editing a post is quick though.

Should I attempt to run through all the rebuilders for thrills?

I ran optimize in mysql if it helped it was a few seconds.only


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: how to check forum for slow posting
Ruben #263531 02/25/2020 4:03 PM
Joined: Apr 2004
Posts: 1,652
Likes: 33
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,652
Likes: 33
A lot of BBCode has been updated for the 7.7.x series to produce more optimized HTML. There wouldnt be much of a server performance boost in rebuilding the content. But you will get cleaner HTML pages with a somewhat smaller database size. More work has gone in to trimming of the BBCode=>HTML heft for 7.7.4.

As for new posts being less quick in the return to the forum/postlist, What else may be causing that is if you only get a single new post (or login) once every few weeks, and there have been thousands of bots who've been spidering your forums, triggering the Post View update counters to update/purge. That is one of the jobs performed when a new post is created, or a new login is successful.

During the past 5 days, you made several post about being DOSSED by bots (thousands per minute). If thats still happening, those bots could also be triggering the Post View counters, among other things.


Current developer of UBB.threads PHP Forum Software // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: how to check forum for slow posting
Ruben #263532 02/25/2020 4:20 PM
Joined: Dec 2003
Posts: 6,091
Likes: 14
Ruben Online Yawn OP
OP Online Yawn
Joined: Dec 2003
Posts: 6,091
Likes: 14
Yes I know but I read a prior post with the same issue and it was supposed to be corrected in ver 7.6.0 I believe
Slow posting Times
I did find by accident that the owner has added several custom islands that have parse errors and most are inline ad's.
The only way I found them was posting tests then deleting the post.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: how to check forum for slow posting
Ruben #263533 02/25/2020 4:23 PM
Joined: Apr 2004
Posts: 1,652
Likes: 33
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,652
Likes: 33
A lot of things have changed since that 7.6.0 post. Whatever was written there was specific to 7.6.0 (and php 5). You are currently on 7.7.3 (with php 7. This is why it was asked what version you were on.

Something that may get fixed in one version, may have changes made to a related item in later versions, which may change the behavior of the overall program, which may break or better/improve or even make the previous changes obsolete.


Current developer of UBB.threads PHP Forum Software // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: how to check forum for slow posting
Ruben #263534 02/25/2020 4:24 PM
Joined: Dec 2003
Posts: 6,091
Likes: 14
Ruben Online Yawn OP
OP Online Yawn
Joined: Dec 2003
Posts: 6,091
Likes: 14
After I cleaned up some custom islands.
A post with around 10 characters is around 23 seconds.
Better but?????

And I think I have the ddos attacks under control now.

Last edited by Ruben; 02/25/2020 4:26 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: how to check forum for slow posting
Ruben #263535 02/25/2020 4:26 PM
Joined: Apr 2004
Posts: 1,652
Likes: 33
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,652
Likes: 33
Originally Posted by Ruben
After I cleaned up some custom islands.
A post with around 10 characters is around 23 seconds.
Better but?????

23 seconds is not normal/typical.

Have a look in your server logs and see where the delay is coming from.
Is it a CPU delay with PHP or is it a slow SQL query delay?

Last edited by isaac; 02/25/2020 4:30 PM.

Current developer of UBB.threads PHP Forum Software // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: how to check forum for slow posting
Ruben #263536 02/25/2020 4:32 PM
Joined: Apr 2004
Posts: 1,652
Likes: 33
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,652
Likes: 33
When did this all begin? I am reminded that you say you're on shared hosting. So were your forums performing just fine for a long while and then all of a sudden this happened? Or was this performance change some related to a script change or increase in server load based on a modified/added script by you or someone else on the same server?

As a random thought, does those happen when you create a new topic, or only when you reply to a topic?
Is your forum email settings configured correctly? How many email notifications are being sent out for your post reply?
Do you get the same page lag when you "Email This Post To Me" ?


Current developer of UBB.threads PHP Forum Software // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: how to check forum for slow posting
Ruben #263537 02/25/2020 4:40 PM
Joined: Dec 2003
Posts: 6,091
Likes: 14
Ruben Online Yawn OP
OP Online Yawn
Joined: Dec 2003
Posts: 6,091
Likes: 14
Actually we changed servers due to bad reliability service from Ipage to inmotionhosting.
It is a pro plan.
But the response is faster with the new host except for posting.

Posting is like 12 seconds where replies is 23 seconds.

Email posts takes a few seconds but not bad. and they work
Server stats
Quote
I CPU Usage
13 / 100 (13%)

Entry Processes
2 / 70 (2.86%)

Number of Processes
6 / 350 (1.71%)

I/O Usage
56 KB/s / 6 MB/s (0.91%)

Physical Memory Usage
26.48 MB / 4 GB (0.65%)

IOPS
4 / 1,024 (0.39%)

There are some errors for cgi that I am working on that can't be found because I renamed them. till I can substitute another program.
And somebody is still attempting to access ultimatebb.cgi
But that is it.
UBB error logs are on and nothing there also.

Last edited by Ruben; 02/25/2020 4:50 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: how to check forum for slow posting
Ruben #263538 02/26/2020 3:29 PM
Joined: Dec 2003
Posts: 6,091
Likes: 14
Ruben Online Yawn OP
OP Online Yawn
Joined: Dec 2003
Posts: 6,091
Likes: 14
All I can say is after implementing and adding agents to the htaccess file per your suggestions seems to have fixed it all for delays.
but I need to wait a day or two to see.
Problem is I rarely post so I have to make test posts to check.
Thanks again Isaac.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
1 member likes this: Gizmo

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
SFS Login Detection Issue [NotABug]
by Ruben - 03/29/2020 1:16 PM
possible bug?
by Morgan - 03/29/2020 5:18 AM
CSS sprites
by Ruben - 03/28/2020 2:29 PM
Who's Online Now
2 members (2 invisible), 102 guests, and 35 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4