If you have an HTML site, it probably uses a very small amount of system resources due to the fact that it's static, but that isn't the situation with dynamic database-driven Internet sites that use PHP scripts and offer much more functions. This type of Internet sites produce load on the hosting server when anyone browses them, because the server requires time to execute the script, to access the database and then to provide the information requested by the visitor's Internet browser. A famous discussion board, for example, stores all usernames and posts inside a database, so some load is produced every single time a thread is opened or a user searches for a particular word. If many people access the forum all at once, or if every search involves checking hundreds of thousands of database entries, this can create high load and affect the functionality of the website. In this regard, CPU and MySQL load data can provide you with info about the site’s overall performance, as you can compare the numbers with your traffic stats to make a decision if the site must be optimized or transferred to a different type of web hosting platform that'll be able to bear the high system load in case the website is popular.
MySQL & Load Stats in Hosting
Using the Hepsia CP, included with all our hosting
packages, you shall be able to to see very detailed data regarding the system resources your Internet sites use. One of the sections shall give you information regarding the CPU load, such as the amount of processing time the server spent, the time it took for your scripts to be executed and the amount of memory they used. Stats are automatically produced every six hours and you may also see the different kinds of processes that generated the most load - PHP, Perl, etc. MySQL load statistics are listed within a different section where you can see all the queries on an hourly, everyday, and so on. basis. You could go back and compare stats from different months to find out whether some update has changed the resource usage if the number of site visitors has not changed much. This way, you will see if your Internet site needs to be optimized, that'll lead to a better functionality and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
If you have a semi-dedicated server
account with us, you'll be able to access quite detailed CPU and MySQL load data that'll give you more information about the overall performance of your websites. 2 sections of the Hepsia CP are committed to the statistics, one for every single type. Within the CPU Load section you could see the execution time of your scripts and the span of time the hosting server processed them. You may also see the types of processes which were executed. Stats are produced every 6 hours, but if needed, you could also check data for previous days or months. The MySQL Load section will show you the total number of database queries daily and each hour, and also the queries to each individual database which you have within your semi-dedicated account. Comparing this info to your traffic stats shall give you important data about how your websites perform and you shall see if you must take some measures to optimize them.