If you have an HTML website, most likely it uses a very small amount of resources because it is static, but this is not the case with dynamic database-driven sites that use PHP scripts and offer much more features. This type of sites generate load on the web hosting server when somebody browses them, as the web server requires time to execute the script, to access the database and then to deliver the content requested by the visitor's Internet browser. A famous discussion board, as an illustration, stores all usernames and posts inside a database, so some load is generated each time a thread is opened or a user searches for a given name. If lots of people access the forum simultaneously, or if each and every search involves checking thousands of database entries, this can produce high load and affect the functionality of the site. In this regard, CPU and MySQL load statistics can give you info about the site’s efficiency, as you can compare the numbers with your traffic stats and see if the site should be optimized or moved to another sort of web hosting platform that'll be able to bear the high system load in the event that the Internet site is extremely popular.
MySQL & Load Stats in Cloud Hosting
Using the Hepsia Control Panel, included with all of our cloud hosting plans, you'll be able to see incredibly detailed stats regarding the system resources your websites use. One of the sections shall give you information regarding the CPU load, such as the amount of processing time the web server spent, the length of time it took for your scripts to be executed and the amount of memory they used. Stats are consistently created every 6 hours and you can also see the different types of processes that generated the most load - PHP, Perl, and so on. MySQL load data are listed in a different section in which you'll be able to see all the queries on a per hour, day-to-day, etc. basis. You'll be able to go back and compare data from different months to find out if some update has changed the resource usage if the amount of website visitors hasn't changed much. That way, you will see if your site needs to be optimized, which will give you a better general performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
If you want to see in depth stats regarding the load created by your sites, it won't take more than several clicks to do this. The Hepsia hosting Control Panel, provided with all semi-dedicated servers we offer, has a section committed to the system resource usage and the data there can tell you if your sites perform well and if the load they generate corresponds to the total amount of received website visitors. The CPU load stats include the script execution time and the time it took for the server to process the requests, plus what types of processes generated the load. The MySQL data shall show you how frequently each database was accessed, and everyday and per hour statistics for the entire account. With both sorts of statistics, you are able to check the numbers for every one of the past days and months, so you could see how the sites perform as the traffic to them increases or after you have applied some update.