If you have an HTML website, it probably uses a really small amount of system resources due to the fact that it is static, but this is not the case with dynamic database-driven websites that use PHP scripts and provide you with considerably more functions. This kind of sites create load on the web hosting server each time anyone browses them, as the server needs time to execute the script, to access the database and then to provide the information requested by the visitor's browser. A widely used discussion board, for example, stores all usernames and posts in a database, so some load is generated every time a thread is opened or an end user searches for a specific phrase. If many people connect to the forum all at once, or if each and every search involves checking hundreds of thousands of database entries, this may produce high load and affect the functionality of the website. In this regard, CPU and MySQL load stats can give you information about the site’s efficiency, as you can compare the numbers with your traffic data to make a decision if the site needs to be optimized or moved to another sort of website hosting platform that'll be able to bear the high system load in case the Internet site is extremely popular.
MySQL & Load Stats in Shared Website Hosting
Using the Hepsia CP, provided with all our shared website hosting packages, you shall be able to to see very comprehensive statistics regarding the system resources which your sites use. One of the sections will give you details about the CPU load, such as the amount of processing time the hosting server spent, the time it took for your scripts to be executed and the amount of memory they used. Statistics are consistently produced every 6 hours and you could also see the kinds of processes that generated the most load - PHP, Perl, etc. MySQL load stats are listed within an individual section where you can see all the queries on a per hour, everyday, etcetera. basis. You can go back and compare data from different months to see if some update has changed the resource usage if the number of site visitors hasn't changed much. Thus, you can determine if your site needs to be optimized, which will lead to a better functionality and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
If you have a semi-dedicated server account with our company, you'll be able to access really detailed CPU and MySQL load data that will give you additional information about the efficiency of your sites. 2 sections of the Hepsia Control Panel are dedicated to the statistics, one for every type. In the CPU Load section you can see the execution time of your scripts and the length of time the server processed them. You may also see the types of processes that were executed. Stats are produced every six hours, but if required, you can also check statistics for previous days or months. The MySQL Load section will show you the whole amount of database queries daily and on an hourly basis, along with the queries to each individual database which you have within your semi-dedicated account. Comparing this data to your traffic stats will give you valuable info about how your sites perform and you will determine if you must take some measures to boost them.