If you have an HTML Internet site, it probably uses a small amount of system resources as it is static, but this is not the situation with dynamic database-driven sites that use PHP scripts and provide a lot more functions. This type of websites produce load on the web hosting server when anyone browses them, simply because the hosting server needs time to execute the script, to access the database and then to provide the info requested by the visitor's Internet browser. A famous discussion board, for example, stores all usernames and posts within a database, so some load is created every single time a thread is opened or a user searches for a certain term. If a lot of people connect to the forum at the same time, or if each search involves checking thousands of database entries, this could generate high load and affect the overall performance of the Internet site. In this regard, CPU and MySQL load data can provide information about the site’s performance, as you can compare the numbers with your traffic data and see if the website needs to be optimized or moved to a different sort of web hosting platform that'll be able to bear the high system load in case the website is extremely popular.
MySQL & Load Stats in Shared Hosting
Using the Hepsia CP, which comes with all our shared hosting plans, you will be able to see incredibly detailed stats concerning the system resources your websites use. One of the sections will give you info on the CPU load, including how much processing time the web server spent, the time it took for your scripts to be executed and the amount of memory they used. Stats are automatically provided every six hours and you can also see the types of processes that generated the most load - PHP, Perl, etc. MySQL load stats are listed inside a different section in which you'll be able to see all the queries on a per hour, day-to-day, etc. basis. You can go back and compare stats from various months to determine if some update has altered the resource usage if the total amount of website visitors hasn't changed much. Thus, you can determine if your Internet site needs to be optimized, that 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 our company, you'll be able to access quite detailed CPU and MySQL load statistics which will give you additional information about the efficiency of your sites. 2 sections of the Hepsia Control Panel are focused on the stats, one for every type. Inside the CPU Load section you could see the execution time of your scripts and the length of time the hosting server processed them. You can also see the different types of processes that were executed. Statistics are created every 6 hours, but if needed, you could also check data for previous days or months. The MySQL Load section shall show you the entire amount of database queries each day and per hour, along with the queries to each individual database which you have within your semi-dedicated account. Comparing this info to your traffic statistics shall give you valuable info about how your websites perform and you will see if you must take some measures to optimize them.