Hosting a website that requires lot of server connections is always a problem for web-administrators. This can slow down the overall performance of your website. I had this problem with my site and I was looking for a solution. After a long search, I found out the cause and also the way to fix it and I would like to share it with you…
Many Dedicated server and VPS owners constantly face this problem with their high traffic websites. Usually this is the main cause websites response time are very high or its opening very slowly. This problem rises when number of Apache connections reaches to limit of MaxClients Directive. You can increase this limit. However, by default this can only be increased upto 256. If you want to increase this limit more than 256 then you must also increase the ServerLimit.
In this article I will guide you how to set MaxClients Directive more than 256. Read more…
Some times there are many many sleep processes in your SQL connection. These sleep connections consume a lot of resources (RAM, cache and processor). This can cause you mysql server slow down. If your mysql server is not responding then the query to the database will take a lot of time. In such situations, your website will open very slowly.
This is really frustrating for webmasters. Here, I will show you how can you get rid of these sleep processes. Read more…
Does your website take too much time to load? The load time of your website could be a crucial parameter that makes it impressive and useful for its end users.
Normally the websites with too many graphics and heavy designs take long time to load. However, sometimes even simple and light weight designed websites take exceptionally long time to load.
While there are many factors that contribute to the load time, one important factor is the SQL performance. If your website uses a very big database and there are many DB queries then this too contributes to the long load times.
In this case you have 2 tricks to enhance the performance of your website:
- Enable Mysql query Cache
- Or Install APC Cache
Read more…
Recent Comments