Hi All,
I have a wordpress site, serving around 1milllion page views per month. Currently the database exceeds 160MB. Although I have installed W3 Total Cache, the server is still under too much load. After initial investigation, it seems that the load is related to MySQL has users get page time-outs while writing to the database (adding new posts, updating old ones etc.)
Current server status is:
Server load 3.12 (8 CPUs)
Memory Used 15.70% (1304952 of 8310752)
Swap Used 0.01% (132 of 2096440)
It has Red Hat 9.3.6 with MySQL 5.0.91
I am desperately looking for means to balance the load and make it easy for the user to do their posts without killing themselves.
Thanks in Advance.