Server is not holding up...
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
8 Replies
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 )
Also, make sure your Apache doesn't let a huge number of children spawn when the server gets loaded.
-Chris
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
@Sog:
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.