php forum
php mysql forum
php mysql smarty
 
Topic Options
#316697 - 02/11/08 02:48 AM Forum slow, VPS isn't helpful, advice? options?
Calpy Offline
Power User

Registered: 12/17/02
Posts: 71

   Forum slow, VPS isn Add to del.icio.us
  Digg Forum slow, VPS isn Digg it
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:

Top
#316698 - 02/11/08 03:47 AM Re: Forum slow, VPS isn't helpful, advice? options? [Re: Calpy]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5115
Loc: 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 - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#316701 - 02/11/08 05:25 PM Re: Forum slow, VPS isn't helpful, advice? options? [Re: Gizmo]
navaho Offline
Veteran

Registered: 10/05/00
Posts: 2517
Loc: 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.

Top
#316706 - 02/13/08 01:36 PM Re: Forum slow, VPS isn't helpful, advice? options? [Re: navaho]
Calpy Offline
Power User

Registered: 12/17/02
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?

Top
#316707 - 02/13/08 02:12 PM Re: Forum slow, VPS isn't helpful, advice? options? [Re: Calpy]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5115
Loc: 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 - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top


Top Posters Last 30 Days
AllenAyres 18
Gizmo 12
sirdude 6
GEN 3
tackaberry 2
Philipp 2
willing 2
Who's Online
0 Registered (), 32 Guests and 7 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Team UBBDev Rides Again!
by Gizmo
Yesterday at 11:45 PM
Multiple Identity Detector
by MattUK
Yesterday at 04:10 PM
[7.3.x] ubb.links
by AllenAyres
08/26/08 09:57 AM
Installing FlashChat with 7.3
by Gizmo
08/23/08 05:36 AM
[7.2.1] - Naked shoutbox
by Iann128
08/22/08 07:27 PM
Nice Ajax Chat
by M4D
08/21/08 10:02 PM
51-card NVIDIA folding rig cranks out 265,200 ppd
by AllenAyres
08/13/08 10:10 PM
New Mods
Installing FlashChat with 7.3
by Paug
08/23/08 12:14 AM
[7.x] AddThis - Social Networking
by Gizmo
08/01/08 01:30 AM
[7.3.x] ubb.links
by AllenAyres
06/20/08 11:50 PM
[7.3] Dissallow quotes more then 3 levels deep
by blaaskaak
06/09/08 09:01 AM
[7.2.1] - Naked shoutbox
by sirdude
08/17/07 10:36 PM
Newest Members
welcomeback1, Paug, Tim Keating, anscers, Murphdog
13324 Registered Users

 

 

 
fusionbb message board php hacks