MySQL & Load Stats
Observe what sort of information is gathered in the MySQL & Load Stats section and just how you can reap the benefits of it.
If you have an HTML Internet site, in all probability it 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 Internet sites that use PHP scripts and provide you with considerably more capabilities. This type of Internet sites create load on the web hosting server anytime someone browses them, as the hosting server requires time to execute the script, to access the database and then to provide the data requested by the visitor's Internet browser. A popular discussion board, for instance, stores all usernames and posts within a database, so some load is created every time a thread is opened or an end user searches for a particular term. If a lot of people access the forum all at once, or if every search involves checking 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 info about the site’s functionality, as you can compare the numbers with your traffic statistics to determine if the website must be optimized or transferred to a different type of hosting platform which will be able to bear the high system load in case the site is very popular.
MySQL & Load Stats in Shared Website Hosting
Using the Hepsia Control Panel, included with all our shared website hosting
offers, you will be able to see really detailed stats regarding the system resources your Internet sites use. One of the sections will give you information regarding the CPU load, such as how much processing time the server spent, the length of time it took for your scripts to be executed and exactly how much memory they used. Statistics are automatically produced every six hours and you could also see the types of processes that produced the most load - PHP, Perl, and so forth. MySQL load data are listed in an individual section in which you are able to see all the queries on an hourly, daily, and so forth. basis. You could go back and compare stats from different months to find out if some update has changed the resource usage if the total amount of website visitors has not changed much. That way, you will see if your Internet site needs to be optimized, that'll contribute to a better functionality and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
If you need to see thorough statistics about the load produced by your websites, it won't take more than a couple of mouse clicks to do that. The Hepsia hosting Control Panel, provided with all semi-dedicated servers
that we offer, features a section dedicated to the system resource usage and the info there will tell you if your websites perform well and if the load they produce corresponds to the total amount of received site visitors. The CPU load statistics include the script execution time and the span of time it took for the web server to process the requests, as well as what sorts of processes generated the load. The MySQL statistics will show you the number of times each database was accessed, and also everyday and by the hour stats for the whole account. With both forms of stats, you'll be able to check the numbers for each of the past days and months, so you could see how the sites perform as the traffic to them grows or after you have applied some update.