The CPU load depends upon the length of time a server spends executing a script every time a visitor opens a webpage on a particular script-driven website. Static HTML websites use barely any CPU time, but it's not the situation with the considerably more complex and functional scripts, which use a database and display dynamic content. The more individuals open this type of a website, the more load shall be generated on the hosting server and if the database is big, the MySQL server shall be loaded too. A good example of what could cause high load is a web-based store with a large number of products. If it is popular, lots of people shall be visiting it all at once and if they search for items, the entire database which contains all of the products shall also be frequently accessed by the script, which will result in high load. In this light, having CPU and MySQL load statistics will give you an idea of how the site is doing, if it needs to be optimized or if you simply just need a more effective web hosting solution - if the Internet site is very popular and the established setup cannot handle the load.
MySQL & Load Stats in Hosting
Using the Hepsia Control Panel, provided with all of our hosting packages, you'll be able to see incredibly comprehensive stats regarding the resources which your sites use. One of the sections shall give you info on the CPU load, such as the amount of processing time the server spent, the amount of time it took for your scripts to be executed and exactly how much memory they used. Statistics are automatically created every six hours and you could also see the different kinds of processes that generated the most load - PHP, Perl, and so on. MySQL load stats are listed in a different section in which you'll be able to see all the queries on an hourly, day-to-day, etc. basis. You'll be able to go back and compare data from various months to find out if some update has altered the resource usage if the amount of site visitors hasn't changed much. That way, you can determine if your website 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 have a semi-dedicated server account with us, you will be able to access quite detailed CPU and MySQL load stats that will give you more information about the overall performance of your sites. Two sections of the Hepsia CP are devoted to the statistics, one for each type. Inside the CPU Load section you could see the execution time of your scripts and how much time the server processed them. You can even see the different kinds of processes that were executed. Statistics are generated every 6 hours, but if needed, you can also check stats for previous days or months. The MySQL Load section will show you the entire amount of database queries per day and on an hourly basis, as well as the queries to each individual database which you have in your semi-dedicated account. Comparing this information to your traffic statistics shall give you important info about how your websites perform and you will see if you need to take some measures to optimize them.