Previous Thread
Next Thread
Print Thread
Rate Thread
Forum slow, VPS isn't helpful, advice? options? #316697
02/11/2008 3:48 AM
02/11/2008 3:48 AM
Joined: Dec 2002
Posts: 71
Calpy Offline OP
Power User
Calpy  Offline OP
Power User

Joined: Dec 2002
Posts: 71
Hi guys,
I'm excitedly awaiting the latest threads release with the other plebeians, but it's taking 20-50 seconds for the front page to load, and then subsequent movement from one page to the next in the forum is 5-15 seconds. And I'm no dummy with ten pal boxes and all that kinda stuff.

Here are the basic forum stats:
Board Statistics
Version: 7.1b5
Total Members: 1153
New in past 24 hours: 1
New in past 7 days: 15
New in past month: 62
Total Forums: 32
Total Topics: 17619
Total Posts: 266651

I have a VPS package with LiquidWeb, which honestly hasn't seemed worth the trouble, as most all my sites (I have 7 of varying popularity) rate as "Slow" or "Very Slow" on Alexa.

I ran the stat.php script in another thread on optimizing SQL and got this:
Quote
Mon Feb 11 00:41:49 PST 2008
top - 00:41:49 up 35 days,
7:44,
0 users,
load average: 1.58,
1.55,
1.49 Tasks: 87 total,
1 running,
86 sleeping,
0 stopped,
0 zombie Cpu(s): 7.7% us,
1.2% sy,
0.1% ni,
86.8% id,
4.2% wa,
0.0% hi,
0.0% si Mem: 1048576k total,
647712k used,
400864k free,
0k buffers Swap: 0k total,
0k used,
0k free,
0k cached PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND 5150 nobody 15 0 0 0:00.01 0.1 1892 896 692 R top Http processes currently running = 24 Mysql processes currently running = 4 Netstat information summary 1 03 TIME_WAIT 1 06 TIME_WAIT 1 14 TIME_WAIT 1 16 TIME_WAIT 1 18 TIME_WAIT 1 2 TIME_WAIT 1 25 TIME_WAIT 1 26 TIME_WAIT 1 3 TIME_WAIT 1 43 TIME_WAIT 1 5 CLOSE 1 5 TIME_WAIT 1 55 TIME_WAIT 1 56 TIME_WAIT 1 58 TIME_WAIT 1 59 TIME_WAIT 1 63 FIN_WAIT2 1 86 TIME_WAIT 1 87 TIME_WAIT 1 88 TIME_WAIT 1 9 TIME_WAIT 1 90 FIN_WAIT2 1 97 TIME_WAIT 1 99 TIME_WAIT 2 CLOSE_WAIT 2 SYN_SENT 2 39 TIME_WAIT 2 6 TIME_WAIT 3 FIN_WAIT1 4 SYN_RECV 5 FIN_WAIT2 7 ESTABLISHED 10 CLOSE 29 LISTEN 52 TIME_WAIT


I also get emails like this every three days or so, since forever, from my VPS cpanel:
[Linked Image]

Sponsored Links
Re: Forum slow, VPS isn't helpful, advice? options? [Re: Calpy] #316698
02/11/2008 4:47 AM
02/11/2008 4:47 AM
Joined: Jan 2000
Posts: 5,941
Portland, OR, USA
Gizmo Online tapedshut

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Online Tapedshut

UBB.Dev / UBB.Wiki Owner
Time Lord

Joined: Jan 2000
Posts: 5,941
Portland, OR, USA
Well, you hae fine load (86% idle) on at least your allocated resources... could be that the "promised" resources aren't being lived up to... You could try another provider if they'e been giving you a lot of problems; I recommend clients for VPS' over to www.webintellects.com (Even our oown AA is there)


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.SitemapsJames Corthell
Re: Forum slow, VPS isn't helpful, advice? options? [Re: Gizmo] #316701
02/11/2008 6:25 PM
02/11/2008 6:25 PM
Joined: Oct 2000
Posts: 2,518
navahoville! :D
N
navaho Offline
Veteran
navaho  Offline
Veteran
N

Joined: Oct 2000
Posts: 2,518
navahoville! :D
You have a lot of services failing and being restarted.

A few here and there is "normal" but that number, every 3 days, is too many.

I've no idea of they have lived up to what's advertised as I've no idea what you bought.

Did you finish tuning MySQL? Did it help?


Picture perfect penmanship here.
Re: Forum slow, VPS isn't helpful, advice? options? [Re: navaho] #316706
02/13/2008 2:36 PM
02/13/2008 2:36 PM
Joined: Dec 2002
Posts: 71
Calpy Offline OP
Power User
Calpy  Offline OP
Power User

Joined: Dec 2002
Posts: 71
I'm still working on it... I removed some things I liked having, such as some links generated by an rss feed from another of our sites and my Amazon affiliates box at the bottom of the page. I also deleted lots of redundant and large files from the server.

As it has done over the last few years, the speed has resolved down to 5-8 seconds of blank page and then everything loads. I never know if it's something I did, something they did or just the random tides of the internet. Sigh!

I will continue to work on optimizing MySQL and my database, and post what happens.

Is there any way to archive old posts so that they are still searchable, but don't figure in the daily default activities of the site's interaction with the database?

Re: Forum slow, VPS isn't helpful, advice? options? [Re: Calpy] #316707
02/13/2008 3:12 PM
02/13/2008 3:12 PM
Joined: Jan 2000
Posts: 5,941
Portland, OR, USA
Gizmo Online tapedshut

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Online Tapedshut

UBB.Dev / UBB.Wiki Owner
Time Lord

Joined: Jan 2000
Posts: 5,941
Portland, OR, USA
There are currently no archival options in UBB.T7; I've been pushing for several over at UBBCentral for a while now... Let's hope Rick has time to revisit the discussion for 7.4.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.SitemapsJames Corthell
Sponsored Links
Re: Forum slow, VPS isn't helpful, advice? options? [Re: Gizmo] #317846
02/24/2009 4:33 PM
02/24/2009 4:33 PM
Joined: Mar 2007
Posts: 16
S
SteveS Offline
Newbie
SteveS  Offline
Newbie
S

Joined: Mar 2007
Posts: 16
I'm at 1.6 million posts, and I would appreciate a simple way to archive.

Re: Forum slow, VPS isn't helpful, advice? options [Re: SteveS] #317855
02/26/2009 1:30 PM
02/26/2009 1:30 PM
Joined: Nov 2003
Posts: 491
SoCal
S
sirdude Offline
Enthusiast
sirdude  Offline
Enthusiast
S

Joined: Nov 2003
Posts: 491
SoCal
i had a very similar problem with one customer.. 2.6 gig DB.. over 2 million posts..

1. tuned my.cnf properly -- mysqltuner.pl is very helpful
2. split the forum into 2 (archive.tld.com and forum.tld.com)

that made the forum.tld.com -- which is 95+% of the traffic scream.. zoom zoom..

then the archive.tld.com was used for searches back in time etc etc..

3. modified the DB for ubbt_POSTS to have a natural reverse time based index.. this made searches 10x faster..
4. added an 'archive these posts' option to copy from main to archive, when needed

works fine smile

so i wouldn't call it 'simple', but it works very well wink

Re: Forum slow, VPS isn't helpful, advice? options [Re: sirdude] #317889
03/06/2009 5:58 PM
03/06/2009 5:58 PM
Joined: Mar 2007
Posts: 16
S
SteveS Offline
Newbie
SteveS  Offline
Newbie
S

Joined: Mar 2007
Posts: 16
"Simple" is always relative! I appreciate the ideas.

Re: Forum slow, VPS isn't helpful, advice? options [Re: SteveS] #317892
03/12/2009 5:19 PM
03/12/2009 5:19 PM
Joined: Feb 2007
Posts: 330
The Netherlands
B
blaaskaak Offline
Yarp™
blaaskaak  Offline
Yarp™
B

Joined: Feb 2007
Posts: 330
The Netherlands
I have a construction like above, we just auto archive everything older then "x" days in certain forums.

Instead of manually selecting what to archive, we can manually select topics to keep, so that they stay in the main forum.

Archive forum is even on a different server in our case.

All in all, it's a few db+ubb changes (fields and code to keep/unkeep the topics), and one extra script that exports the topic data as mysql queries.

Sort of "archive.php" that as a result gives a mysql dump of one complete topic.

The receiving end needs to do cronjobs to receive the data, and run those queries. And afterwards call a fixup scripts that updates some tables in ubb with the new posts information.

I am more then willing to share the code, but I won't do this public here yet because "as-is" you need to be a bit of a techy. PM me if you want it.

Owh, and because our forum doesn't use attachments in any user forums, my archiving stuff does not take those in account.

Last edited by blaaskaak; 03/12/2009 5:28 PM.

[Linked Image]

Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
JAISP
JAISP
PA
Posts: 458
Joined: February 2008
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,453
Posts293,495
Members13,800
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,941
Greg Hard 5,533
Top Posters(30 Days)
isaac 8
Gizmo 3
Today's Statistics
Currently Online 852
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 21
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.3
(Snapshot build 20180915.dev)
Page Time: 0.045s Queries: 15 (0.016s) Memory: 3.3072 MB (Peak: 3.6719 MB) Zlib enabled. Server Time: 2018-09-21 19:25:55 UTC