| Author |
Message |
Drowned
Joined: 19 Oct 2003
Posts: 17
Location: Guatemala
|
| Posted: Thu Oct 23, 2003 6:17 pm Post subject: Server is not holding up... |
|
|
I run a vbulletin forum with around 900 members and around 1000 posts a day... I'm not really sure if my forum is a resource hog but I'm currently on plan Linode 64 and it's not holding up. I'm not sure If I didn't configure mysql and apache right but like 3 or 4 times a day my server load goes through the roof and everything halts :( I can't even login to my shell account...
Perhaps somebody can guide me or give me some mysql optimization tips? Perhaps the people from linode can tell me what is wrong exactly? cause it only happens like 3 or 4 times, the rest of the day the server load averages 0.5 :?: |
|
| Back to top |
|
eadz
Joined: 08 Sep 2003
Posts: 9
|
| Posted: Thu Oct 23, 2003 6:18 pm Post subject: |
|
|
Hi, you probally don't have enough ram.
A few optimization tips:
Use mysql 4 with the query cache
Use apache's mod_throttle to stop bad spiders/people who try to download the whole site.
Use phpbb's template caching ( in version 2.0.6 there is a contrib directory with 2 replacements for templating ) |
|
| Back to top |
|
caker
Joined: 15 Apr 2003
Posts: 2386
Location: Galloway, NJ
|
| Posted: Thu Oct 23, 2003 9:24 pm Post subject: |
|
|
It sounds to me like when you get lots of users on the site at once, you start swap storming .. you want to avoid anything that thrashes swap. Without knowing your specifics, check the mysql server params page:
http://www.mysql.com/doc/en/Server_parameters.html
Also, make sure your Apache doesn't let a huge number of children spawn when the server gets loaded.
-Chris |
|
| Back to top |
|
adamgent
Joined: 23 Jun 2003
Posts: 261
|
| Posted: Fri Oct 24, 2003 5:29 am Post subject: |
|
|
hi,
There should be in the conf directory for my sql a high performance conf file, it may be worth while giving that a try.
Adam |
|
| Back to top |
|
n00bie
Joined: 21 Oct 2003
Posts: 3
|
| Posted: Fri Oct 24, 2003 12:31 pm Post subject: |
|
|
Easy job just use mod_gzip and there are more methods from the link below:
http://www.vbulletin.com/forum/showthread.php?s=&threadid=17943 |
|
| Back to top |
|
mikegrb
Joined: 16 Oct 2003
Posts: 264
Location: Dr Wierd's Lab, South Jersey Shore
|
| Posted: Fri Oct 24, 2003 12:45 pm Post subject: |
|
|
| mod_gzip might hurt more then help. It certainly sounds like bandwidth isn't the problem, it's cpu and/or memory. mod_gzip, though lessening bandwidth usage, will increase cpu and memory as the pages have to be compressed to be sent out to the user. |
|
| Back to top |
|
Drowned
Joined: 19 Oct 2003
Posts: 17
Location: Guatemala
|
| Posted: Fri Oct 24, 2003 3:48 pm Post subject: |
|
|
| Yes, bandwidth is not the problem... it's cpu and memory :( I configured mysql a while ago and noticed a huge improvment, I hope it stays this way :) I also upgraded to Linode 128 just in case... :) |
|
| Back to top |
|
Sog
Joined: 16 Aug 2003
Posts: 8
|
| Posted: Sat Oct 25, 2003 10:17 am Post subject: Message Boards |
|
|
| I have heard that (popular) message boards are CPU hogs. I am not sure how big one would be before you have to throw more CPU and Memory at it. I have a small message board on my Linode 128 that does about 30 messages a day with < 50 users. It does just fine. |
|
| Back to top |
|
Drowned
Joined: 19 Oct 2003
Posts: 17
Location: Guatemala
|
| Posted: Sun Oct 26, 2003 1:04 am Post subject: Re: Message Boards |
|
|
Sog wrote: I have heard that (popular) message boards are CPU hogs. I am not sure how big one would be before you have to throw more CPU and Memory at it. I have a small message board on my Linode 128 that does about 30 messages a day with < 50 users. It does just fine.
:( I get around 1000 new posts a day :( My board has 900 members... I hope Linode 128 holds up then :? :? :? |
|
| Back to top |
|
| |
