|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
Hello all,
In general, how would you go about diagnosing slow posting times?
It seems to take better than 10 seconds for a simple one sentence reply to show up after hitting the post button.
Any help would be greatly appreciated.
Bill
|
|
|
|
Joined: Apr 2004
Posts: 1,945 Likes: 145
|
Joined: Apr 2004
Posts: 1,945 Likes: 145 |
Are you on a shared or a dedicated server?
if you have a large forum which gets lots of spiders, but hardly any new posts (once a week or less), then the triggered micro maintenance which is done after each post, can become rather large.
updating the "post view" counters for all posts, is done after each new post is made. if the lapse between new posts is a long period of time, and there are several new post views, the micro trigger could be your answer, in addition to if youre on a shared server where your host has limited the amount of resources to your account, or another website is hogging them.
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
Its a VPS 1000S (4 - 6GB RAM) package with Inmotion Hosting It goes pretty quick from page to page, but making a post is real slow. My last was 10 - 15 sec http://www.electrical-contractor.net/forums/Any suggestions? (I'm not too tech savvy) Bill
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Bill. You have had ubb for many years. And been through many upgrades. such as I see posts from 10/2000. Possibly you need to do some clean up. I think you have server logs enabled. I would look for any indication of connection issues to the database. I would start with that.and or clean them out if they are excessive.. If you know the folder they are saved in you can delete them faster than using the ubb to delete them one at a time. But you may get some better performance by clearing cache and optimizing tables. This can be done from the ubb control panel.
I tried to login to your site but my email has changed since the last time I visited.
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 |
@ECNet I looked at your "Who's Online" page, and noticed your site is getting seriously spidered. Every time a post is viewed, a line is written to the TOPIC_VIEWS table. The only time that table is ever flushed in UBB.threads 7.5.x is when a new post is created. The TOPIC_VIEWS table can easily hit 1,000 lines every few minutes. This normally shouldnt be a problem if you have an active forum. But for many of us who've had forums for a very long time, and are now using our forums as a CMS for all the important information thats been created over the years, a new topic/post can be days away. Heck, we've talked about everything already -- and the questions have already all been answered. So the forum is basically a gold mine of answers and information. Anyways, adding an additional trigger to process the TOPIC_VIEWS table is just whats needed for us. This will handle the job every time someone visits the Login page. It processes the TOPIC_VIEWS and updates the view count within the TOPICS table, then purges and gives you a fresh TOPIC_VIEWS record to work with. This is the normal procedure for when a new post is added. I've just updated the code so that the procedure is also triggered with each Login page visit. This should help to keep the TOPIC_VIEWS table from getting out of hand, by allowing it to be processed more often. This update has been added to UBB.threads 7.6.0, but I am posting here, because it sounds like you (and others) might need it now. Cheers! FIND IN /scripts/login.inc.php (around line 27)
// TRIGGER: pointer_delete
include("libs/triggers.inc.php");
trigger_pointer_delete();
trigger_subscriptions();
ADD JUST BELOW IT
// TRIGGER: Update the views
update_views_counter();
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
I never even noticed the large number of spiders.
But Isaac gave you a possible fix that has been a long time waiting.for the different cache flushes. Since the talk of version 8 when Rick was around.
But to be honest it is probably still time to do some housekeeping on all the logs and tables and possibly some posts.
Also I noticed that Zlib compression is disabled. For me that always helped for other processes.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
Bill. You have had ubb for many years. And been through many upgrades. such as I see posts from 10/2000. Possibly you need to do some clean up. I think you have server logs enabled. I would look for any indication of connection issues to the database. I would start with that.and or clean them out if they are excessive.. If you know the folder they are saved in you can delete them faster than using the ubb to delete them one at a time. But you may get some better performance by clearing cache and optimizing tables. This can be done from the ubb control panel.
I tried to login to your site but my email has changed since the last time I visited. Ruben, I do have them enabled, but there's no Error Logs. As far as Optimizing Tables is there a way to do them all at once or must it be one at a time? Should I close down for that? I did enable Zlib and put Isaac's code in, but it doesn't seem better. I've been blocking bad spiders since last night, they were all mostly Baiduspider and AhrefsBot at that time, now I see a lot of Google and some other Friendlies - that might be because I just got the latest UBB.Sitemaps operational with the SEO Friendly modifications. If you could take the time to login over there and see firsthand I'd really appreciate it. Send me a pm with a current email address I'll put it under your username at ECN and send you the password. ** BTW, it took me logging in over 10 times to get to write this Post. After Logging in I'd go to this thread and find out I wasn't logged in anymore... ?? Bill
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
I put in a support ticket over at Inmotion pointing them to my Forum and described the problem in general. Here is the response I got: The latency is likely being caused by the outbound filter. You would be able to disable this logged in as the root user in Web Hosting Manager (WHM), and going to Exim Configuration Manager. You would then turn off outbound scanning. Does that sound like it might be a solution for slow (30 sec) posting problems? Or, unrelated? Bill
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
I would do them any maintenance on one table at a time, as if one errors out you'd be more likely to pay attention to any associated error.
Zlib will compress the output of pages sent to your users, they would SEE things faster, but it would still take the same amount of time to execute any queries.
Isaac's additional code simply runs the trigger every time someone logs in, in addition to just every time a post is made; you'll notice it "as time goes by", it won't show immediately, perhaps after a couple of days of users using the forums on a normal basis.
The UBB.Sitemaps and UBB.MemberMaps scripts only really aid in more bot traffic for search engines that support them (such as Bing and Google), other bots would have to be told about where the sitemap is to be able to use them; but after you've provided them with the url to your sitemaps they'll process them as needed, you can tell them to reindex them through either Google Webmaster Tools or the Bing Tools centers.
Any filters on the machine could add to additional time (just like a firewall on a computer would add to overall usage); you'd have to play with it to decide if it'll be faster for your server; the more available resources that you have available, the faster everything is going to be able to run.
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
I sent you the pm. Like I said the zlib will improve other processes but not this issue. also on optimizing, there are like 64 tables. I would start with any table that has topics or posts in the name. They probably are the largest tables and the oldest data. If one of the tables bark back you may need to run a repair which can't be done from ubb but from the mysql console. also before a repair I would make a backup of the database. If it were me I would close the board during optimizing. But the caveat is the posts tables are probably on the large side and may take a long while if they are cluttered with trash. it runs fairly quick if nothing needs to be done.
Last edited by Ruben; 01/18/2017 11:12 AM.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
Is there a way to Archive old posts where they won't slow things down (instead of pruning)?
Is there a way to disable Topic Views for a specific Forum? And, if so would that speed things up?
Bill
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Is there a way to Archive old posts where they won't slow things down (instead of pruning)?
Is there a way to disable Topic Views for a specific Forum? And, if so would that speed things up?
Bill I don't think either one of those options will improve your current issue. But you do have topic views already turned off.
Last edited by Ruben; 01/18/2017 3:48 PM.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
finally had to do a rebuild of posts but it appears better now. Let me know!
Last edited by Ruben; 01/18/2017 7:32 PM.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
finally had to do a rebuild of posts but it appears better now. Let me know! Absolutely!! Thanks for all your Help on this!! Bill
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
It appears that using the re-builders for posts tool fixed the problem.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
It moves nicely now! I'm very happy I didn't have to prune those older topics!! Bill
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
FWIW, if your site makes you money, never just blindly prune old topics; you'd want to go in and make sure that they do not contain any potentially valuable information, even if one had to scale up their site resources (processor speed, cores, or ram) to retain content.
The largest UBB.threads forums I've worked on have 96+GB Ram, I've seen it all.
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
0 members (),
1,020
guests, and
174
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|