I need a good server admin that can fix my problem. I have an Intel(R) Xeon(R) CPU E31270 @ 3.40GHz server 1GBPs port SSD HD with 12GB RAM Im using wordpress, inside my wordpress i used w3 total cache, they said it will help my page to loads faster and reduce sever load. In my case, my server always gets high load ESPECIALLY if im adding or editing pages or posts inside my Dashboard or wp-admin. MYSQL gets the highest loads, sometimes it reaches 700 %cpu and my server will suddenly freeze until the loads goes down. The problem is always happening if im adding or editing posts. The worst is sometimes the mysql restarts on its own and sometimes server goes offline. If yur familiar how to fix this or how to optimize this, please help me. PM me how much for this job. Please make it cheap. Thank you
How much traffic do you have hitting this server, out of curiosity? Do the issues seem intermittent depending on time of day?
High load (vice high memory use) is quite often a disk i/o issue. Unfortunately, that is a typical experience with WordPress admin performance. Caching (W3 or otherwise) will have no effect on WP admin issues. Part might be write performance of your SSD drive. Less expensive SSD drives tend to have much lower write speeds v. read speeds. Your box seems to have plenty of resources to handle 20K UV, other than the admin issue, but you should ensure that apache is optimized so memory issues are not exacerbating the load problems. The solution? I would look at three things: 1. Work in the WP admin during lower traffic periods. 2. Optimize MySQL. http://mysqltuner.pl/mysqltuner.pl can help. 3. Consider offloading some of the server load. A CDN, CloudFlare and, perhaps, a separate MySQL server will help.