I'm running a mac mini, which Richard kindly helped me get a mail server on. The only think other than that I run is a web forum for football supporters. I'm having real problems with the mysql/apache load.
Basically the server slows to a crawl on lunchtimes. I've got about 1.5k users, which can balloon up to 2.5k if something big hits the news. Average hits per day is somewhere between 50k and 90k (again if there's some big story).
Does anyone have any ideas? When I look at top I'm seeing MySQL sometimes at 150% plus of CPU processes, and the CPU itself maxed out between User and System with no idle. Also the average CPU load seems to be 2.5 plus. All these things aren't supposed to be I'm pretty sure, but I am unsure if it's a software issue or a hardware one. The forum software I run is phpbb3.
For wordpress you can use a caching plugin which will help in caching pages which means that MySQL isn't accessed that much. I don't use phpbb so I'm not that experienced with their options.
#
Hi
I'm running a mac mini, which Richard kindly helped me get a mail server on. The only think other than that I run is a web forum for football supporters. I'm having real problems with the mysql/apache load.
Basically the server slows to a crawl on lunchtimes. I've got about 1.5k users, which can balloon up to 2.5k if something big hits the news. Average hits per day is somewhere between 50k and 90k (again if there's some big story).
Does anyone have any ideas? When I look at top I'm seeing MySQL sometimes at 150% plus of CPU processes, and the CPU itself maxed out between User and System with no idle. Also the average CPU load seems to be 2.5 plus. All these things aren't supposed to be I'm pretty sure, but I am unsure if it's a software issue or a hardware one. The forum software I run is phpbb3.
Any ideas?
#
For wordpress you can use a caching plugin which will help in caching pages which means that MySQL isn't accessed that much. I don't use phpbb so I'm not that experienced with their options.