If you have an HTML site, most likely it uses a small amount of resources because it is static, but that isn't the case with dynamic database-driven sites that use PHP scripts and offer considerably more features. Such sites generate load on the hosting server when someone browses them, simply because the hosting server needs time to execute the script, to access the database and then to provide the information requested by the visitor's web browser. A popular discussion board, as an illustration, stores all usernames and posts inside a database, so some load is created each time a thread is opened or an end user searches for a given term. If lots of people access the forum at the same time, or if each and every search involves checking hundreds of thousands of database entries, this could generate high load and affect the functionality of the Internet 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 statistics to determine if the site needs to be optimized or migrated to a new sort of web hosting platform that will be able to bear the high system load in case the site is very popular.

MySQL & Load Stats in Hosting

Using the Hepsia Control Panel, included with all our hosting offers, you shall be able to to see rather detailed data regarding the system resources that your sites use. One of the sections will give you information about the CPU load, such as how much processing time the web server spent, the span of time it took for your scripts to be executed and exactly how much memory they used. Statistics are automatically generated every six hours and you may also see the different kinds of processes that produced the most load - PHP, Perl, and so forth. MySQL load statistics are listed within a separate section where you could see all the queries on an hourly, daily, and so forth. basis. You'll be able to go back and compare statistics from various months to determine if some update has changed the resource usage if the number of visitors hasn't changed much. In this way, you can determine if your Internet site needs to be optimized, which will lead to 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 will be able to access very detailed CPU and MySQL load data that will give you addiitional information about the efficiency of your sites. Two sections of the Hepsia Control Panel are dedicated to the stats, one for each and every type. Inside the CPU Load section you could see the execution time of your scripts and the length of time the server processed them. Additionally you can see the different types of processes that were executed. Stats are produced every six hours, but if needed, you can also check statistics for previous days or months. The MySQL Load section shall show you the total amount of database queries daily and each hour, and also the queries to each individual database which you have in your semi-dedicated account. Comparing this info to your traffic statistics shall give you useful info about how your websites perform and you will see if you must take some measures to optimize them.