Performance Tuning Backend Mysql

If you have multiple servers, the first place to put your RAM is in the database server. If you can afford it, get enough RAM to get fit your entire database into memory. This shouldn’t be too hard; we’ve developed a site with more than half a million newspaper articles, and it took under 2GB of space.

Next, max out the RAM on your Web server. The ideal situation is one where neither server swaps

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License