If you have an HTML site, most likely it uses a small amount of resources due to the fact that it's static, but that isn't so with dynamic database-driven sites that use PHP scripts and provide far more functions. This type of Internet sites create load on the web hosting server anytime someone browses them, since the hosting server needs time to execute the script, to access the database and then to deliver the content requested by the visitor's browser. A well known discussion board, for example, stores all usernames and posts within a database, so some load is produced each time a thread is opened or a user searches for a specific phrase. If many people connect to the forum simultaneously, or if each search involves checking tens of thousands of database entries, this can produce high load and affect the overall performance of the Internet site. In this regard, CPU and MySQL load data can provide you with data about the site’s functionality, as you can compare the numbers with your traffic data to decide if the website must be optimized or migrated to another sort of web hosting platform that will be able to bear the high system load if the site is popular.
MySQL & Load Stats in Hosting
Using the Hepsia CP, provided with all of our hosting packages, you shall be able to to see incredibly detailed stats about the resources 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 length of time it took for your scripts to be executed and the amount of memory they used. Statistics are routinely created every six hours and you can also see the kinds of processes that produced the most load - PHP, Perl, and so on. MySQL load statistics are listed in a different section where you are able to see all the queries on a per hour, everyday, etcetera. basis. You'll be able to go back and compare stats from various months to determine if some update has transformed the resource usage if the total amount of website visitors has not changed much. In this way, you can determine if your Internet site needs to be optimized, that'll give you a better overall performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
As our system keeps detailed stats for the load that each semi-dedicated server account produces, you will be aware of how your Internet sites perform at any time. As soon as you log in to the Hepsia CP, which comes with each and every account, you should check out the section devoted to the system load. In it, you will see the processing time our system spent on your scripts, the time it took for the scripts to be actually executed and what sorts of processes generated the load - cron jobs, PHP pages, Perl scripts, and so forth. You may also see the amount of queries to every single database inside your semi-dedicated account, the total daily statistics for the account altogether, plus the average hourly rate. With both the CPU and the MySQL load statistics, you may always go back to past days or months and compare the functionality of your Internet sites after some update or after a major increase in the number of your website visitors.