I have a website that gets a lot of visitors a month. And the server cannot handle the traffic. I have a dedicated server. How can I run the site on multiple dedicated servers?
This is what load balancers and cache servers are for. While I have not set anything up myself, it is my unerstsanding that you have a few options from using a service like Akamai to having a load balancer as your handling server and then pass requests to servers that … Read More
I'd pay more attention to the [slow query log](https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html) and simple page stats from your logs than hunting down `select *` queries. The slow query log will highlight all queries that take more than `x` time (configurable by you). Your logging system or analytics should tell you which pages take … Read More
Edited by ryantroop: finished thought, came back and shared it :-P
Are you able to help answer this sponsored question?
Questions asked by members who have earned a lot of community kudos are featured in order to give back and encourage quality replies.