If you have an HTML Internet site, it likely uses a small amount of system resources simply because it is static, but this isn't the case with dynamic database-driven sites that use PHP scripts and offer far more capabilities. This type of websites produce load on the website hosting server every time somebody browses them, due to the fact that the web server requires time to execute the script, to access the database and then to deliver the info requested by the visitor's Internet browser. A well-known discussion board, for example, stores all usernames and posts in a database, so some load is created every time a thread is opened or an end user looks for a certain phrase. If a lot of people access the forum all at once, or if each search involves checking a large number of database entries, this may create high load and affect the overall performance of the Internet site. In this regard, CPU and MySQL load data can provide you with information about the site’s functionality, as you can compare the numbers with your traffic data to make a decision if the site needs to be optimized or migrated to a new type of website hosting platform which will be able to bear the high system load if the website is really popular.
MySQL & Load Stats in Web Hosting
Using the Hepsia Control Panel, included with all of our web hosting
packages, you will be able to see really comprehensive statistics concerning the resources which your sites use. One of the sections shall give you info on the CPU load, like how much processing time the web server spent, the time it took for your scripts to be executed and how much memory they used. Stats are routinely created every six hours and you may also see the types of processes that produced the most load - PHP, Perl, and so forth. MySQL load stats are listed within a different section in which you'll be able to see all the queries on an hourly, everyday, etc. basis. You'll be able to go back and compare statistics from different months to determine if some update has transformed the resource usage if the number of website visitors has not changed much. This way, you can determine if your Internet site needs to be optimized, which will give you a better overall performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
If you need to see detailed statistics about the load created by your sites, it won't take more than a few mouse clicks to do this. The Hepsia hosting CP, supplied with all semi-dedicated servers
that we offer, has a section focused on the system resource usage and the data there can tell you if your websites operate properly and if the load they produce corresponds to the amount of received website visitors. The CPU load data include the script execution time and the time it took for the machine to process the requests, and what types of processes produced the load. The MySQL stats shall show you how often each individual database was accessed, plus everyday and by the hour stats for the whole account. With both sorts of stats, you'll be able to check the numbers for any of the past days and months, so you could see how sites perform as the traffic to them grows or once you've applied some update.