If you have an HTML site, it likely uses a very small amount of resources as it's static, but this isn't so with dynamic database-driven sites that use PHP scripts and provide you with far more capabilities. Such websites generate load on the website hosting server when somebody browses them, simply because the server requires time to execute the script, to access the database and then to deliver the information requested by the visitor's Internet browser. A widely used discussion board, for example, stores all usernames and posts within a database, so some load is produced every single time a thread is opened or an end user searches for a particular word. If lots of people access the forum concurrently, or if every single search involves checking thousands of database entries, this can create high load and affect the functionality of the Internet site. In this regard, CPU and MySQL load statistics can provide info about the site’s overall performance, as you can compare the numbers with your traffic data to make a decision if the website needs to be optimized or moved to another kind of website hosting platform which will be able to bear the high system load in case the website is popular.

MySQL & Load Stats in Website Hosting

Using the Hepsia Control Panel, which comes with all our website hosting offers, you will be able to see rather detailed stats about the resources that your Internet sites use. One of the sections shall give you details about the CPU load, such as the amount of processing time the web server spent, the amount of time it took for your scripts to be executed and exactly how much memory they used. Stats are consistently created every six hours and you could also see the kinds of processes that generated the most load - PHP, Perl, and so forth. MySQL load stats are listed in a separate section where you are able to see all the queries on a per hour, day-to-day, etc. basis. You can go back and compare statistics from various months to see if some update has altered the resource usage if the number of site visitors hasn't changed much. This way, you can see if your site needs to be optimized, which will result in a better general performance and an improved user experience.

MySQL & Load Stats in Semi-dedicated Hosting

If you need to see comprehensive statistics regarding the load created by your sites, it won't take more than just a few mouse clicks to do this. The Hepsia hosting Control Panel, supplied with all semi-dedicated servers we offer, has a section dedicated to the system resource usage and the data there shall tell you if your sites operate properly and if the load they generate corresponds to the amount of received visitors. The CPU load stats include the script execution time and the length of time it took for the web server to process the requests, and what sorts of processes created the load. The MySQL statistics shall show you how many times each individual database was accessed, plus everyday and by the hour data for the whole account. With both types of stats, you are able to check the numbers for any of the past days and months, so you can easily see how sites perform as the traffic to them rises or after you have applied some update.