MySQL & Load Stats
The MySQL & Load Stats will quietly gather data while your website is functioning. Discover why you should check them out on a regular basis.
If you have an HTML website, it probably uses a small amount of system resources because it is static, but this is not the situation with dynamic database-driven websites that use PHP scripts and offer you a lot more capabilities. Such Internet sites generate load on the web hosting server every time somebody browses them, since the hosting server requires 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 instance, stores all usernames and posts inside a database, so some load is generated any time a thread is opened or a user searches for a particular name. If many people access the forum at the same time, or if each search involves checking tens of thousands of database entries, this could generate high load and affect the efficiency of the website. In this regard, CPU and MySQL load stats can provide information about the site’s functionality, as you can compare the numbers with your traffic data to decide if the website has to be optimized or moved to another kind of hosting platform that will be able to bear the high system load in the event that the website is popular.
MySQL & Load Stats in Cloud Website Hosting
Using the Hepsia CP, which comes with all our cloud website hosting
offers, you will be able to see very comprehensive statistics about the system resources which your sites use. One of the sections will give you information regarding the CPU load, such as how much processing time the hosting server spent, the length of time it took for your scripts to be executed and what amount of memory they used. Statistics are routinely generated every 6 hours and you may also see the different kinds of processes that produced the most load - PHP, Perl, and so on. MySQL load stats are listed inside an individual section in which you are able to see all the queries on an hourly, everyday, and so forth. basis. You could go back and compare data from different months to determine if some update has altered the resource usage if the number of site visitors hasn't changed much. This way, you can see if your Internet site needs to be optimized, that'll lead to a better performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
If you would like to see comprehensive stats regarding the load created by your websites, it won't take more than a few mouse clicks to do that. The Hepsia hosting Control Panel, which comes with all semi-dedicated servers
that we offer, has a section dedicated to the system resource usage and the data there can tell you if your websites perform well and if the load they create corresponds to the number of received website visitors. The CPU load statistics include the script execution time and the amount of time it took for the hosting server to process the requests, as well as what types of processes produced the load. The MySQL statistics will show you how often every single database was accessed, and daily and by the hour stats for the whole account. With both kinds of statistics, you can check the numbers for each of the past days and months, so you can easily see how the websites perform as the traffic to them increases or after you have applied some update.