|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
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
|
|
|
|
Joined: Apr 2004
Posts: 1,945 Likes: 145
|
Joined: Apr 2004
Posts: 1,945 Likes: 145 |
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 hostingBASIC (Standard Performance) vs PRO (fewer accounts per server @ High Performance) https://www.bluehost.com/hosting/sharedSTABLEHOST shared hostingSTARTER (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
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
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
|
|
|
|
Joined: Apr 2004
Posts: 1,945 Likes: 145
|
Joined: Apr 2004
Posts: 1,945 Likes: 145 |
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.
|
1 member likes this:
cegadm |
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
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 TimesI 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
|
|
|
|
Joined: Apr 2004
Posts: 1,945 Likes: 145
|
Joined: Apr 2004
Posts: 1,945 Likes: 145 |
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.
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
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
|
|
|
|
Joined: Apr 2004
Posts: 1,945 Likes: 145
|
Joined: Apr 2004
Posts: 1,945 Likes: 145 |
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.
|
|
|
|
Joined: Apr 2004
Posts: 1,945 Likes: 145
|
Joined: Apr 2004
Posts: 1,945 Likes: 145 |
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" ?
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
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 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
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
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 |
|
|
1 members (Ruben),
1,277
guests, and
207
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|