If you have an HTML website, most likely it uses a small amount of resources simply because it is static, but this isn't the case with dynamic database-driven websites that use PHP scripts and offer far more capabilities. Such sites generate load on the hosting server anytime anyone browses them, due to the fact that the web server needs time to execute the script, to access the database and then to provide the data requested by the visitor's web browser. A popular discussion board, for example, stores all usernames and posts in a database, so some load is created every single time a thread is opened or an end user looks for a certain phrase. If lots of people access the forum at the same time, or if every single search involves checking hundreds of thousands of database entries, this can produce high load and affect the functionality of the website. In this regard, CPU and MySQL load statistics can give you information about the site’s overall performance, as you can compare the numbers with your traffic data and see if the site has to be optimized or transferred to a new kind of website hosting platform that'll be able to bear the high system load in the event that the site is popular.
MySQL & Load Stats in Web Hosting
Using the Hepsia Control Panel, included with all our web hosting packages, you'll be able to see very detailed stats about the resources your sites use. One of the sections shall give you information regarding the CPU load, like the amount of processing time the hosting server spent, the span of time it took for your scripts to be executed and exactly how much memory they used. Statistics are routinely produced every 6 hours and you could also see the types of processes that generated the most load - PHP, Perl, etc. MySQL load statistics are listed in a separate section where you could see all the queries on a per hour, everyday, and so forth. basis. You could go back and compare stats from various months to see if some update has transformed the resource usage if the amount of visitors hasn't changed much. Thus, you will see if your website needs to be optimized, that'll give you a better functionality and an improved user experience.