On Mar 16, 2014 6:33 PM, "晒太阳的冰" <zoglun(a)gmail.com> wrote:
Usually when there are more than 600 people online
(data
by google analytics) at the same time the website will become unstable.
Would be good to know more about what's happening when those 600 people are
on. What are they doing?
Probably the most important thing you can do is add a parser cache. Add
memcache to
http://www.mediawiki.org/wiki/Manual:$wgMainCacheType and the
parser cache conf option will inherit the main value.
Move MySQL to its own box and tune it. Analyze DB size vs. RAM. Can fit all
indexes in RAM? watch overall box stats like `vmstat 1`. A lot of io?
iowait? swapping? If its overloaded then maybe add a slave and move some of
the traffic to the slave. (Or tune MySQL/add RAM. but first memcache or
redis. see above)
http://www.mediawiki.org/wiki/Manual:$wgDBservers
-Jeremy