MySQL & Load Stats
The MySQL & Load Stats will quietly gather data while your site is functioning. See why you should check them out frequently.
If you have an HTML site, most likely it uses a really small amount of system resources simply because it is static, but this isn't the situation with dynamic database-driven sites that use PHP scripts and offer you way more features. This sort of Internet sites produce load on the web hosting server every time anyone browses them, as the server needs time to execute the script, to access the database and then to supply the info requested by the visitor's Internet browser. A widely used discussion board, for instance, stores all usernames and posts within a database, so some load is produced any time a thread is opened or a user searches for a certain word. If lots of people connect to the forum at the same time, or if each search involves checking thousands of database entries, this can create high load and affect the functionality of the website. In this regard, CPU and MySQL load data can provide data about the site’s functionality, as you can compare the numbers with your traffic stats and see if the Internet site should be optimized or moved to a new type of hosting platform that will be able to bear the high system load in the event that the site is very popular.
MySQL & Load Stats in Cloud Hosting
Using the Hepsia Control Panel, which comes with all of our cloud hosting
offers, you'll be able to see rather comprehensive stats regarding the system resources which your Internet sites use. One of the sections shall give you details about the CPU load, such as the amount of processing time the web server spent, the time it took for your scripts to be executed and the amount of memory they used. Stats are consistently created every six hours and you could also see the different kinds of processes that generated the most load - PHP, Perl, and so on. MySQL load stats are listed in an individual section where you could see all the queries on an hourly, everyday, etcetera. basis. You'll be able to go back and compare stats from different months to find out whether some update has altered the resource usage if the total amount of website visitors has not changed much. That way, you can determine if your Internet site needs to be optimized, which will result in a better performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
If you want to see thorough statistics regarding the load generated by your websites, it will not take more than a few mouse clicks to do this. The Hepsia hosting CP, included with all semi-dedicated servers
that we offer, has a section focused on the system resource usage and the info there can tell you if your websites function properly and if the load they produce corresponds to the amount of received site visitors. The CPU load data include the script execution time and the span of time it took for the web server to process the requests, and also what sorts of processes produced the load. The MySQL stats will show you the number of times every database was accessed, and everyday and by the hour stats for the entire account. With both kinds of stats, you'll be able to check the numbers for any of the past days and months, so you could see how the websites perform as the traffic to them increases or once you've applied some update.