MySQL & Load Stats
What sort of information is provided in the MySQL & Load Stats section? How do you make use of it?
If you have an HTML Internet site, it probably uses a really small amount of resources as it is static, but this is not the case with dynamic database-driven Internet sites that use PHP scripts and provide you with way more functions. Such websites generate load on the website hosting server every time someone browses them, simply because 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 popular discussion board, for instance, stores all usernames and posts in a database, so some load is produced any time a thread is opened or an end user searches for a particular phrase. If many people access the forum all at once, or if every single search involves checking thousands of database entries, this could create high load and affect the performance of the Internet site. In this regard, CPU and MySQL load data can present you with info about the site’s functionality, as you can compare the numbers with your traffic stats to make a decision if the Internet site has to be optimized or moved to another type of website hosting platform that will be able to bear the high system load in case the site is extremely popular.
-
MySQL & Load Stats in Cloud Web Hosting
Using the Hepsia CP, included with all our
cloud web hosting packages, you will be able to see incredibly comprehensive stats concerning the system resources which your sites use. One of the sections shall give you details about the CPU load, including how much processing time the server spent, the time it took for your scripts to be executed and how much memory they used. Statistics are routinely provided every 6 hours and you can also see the types of processes that generated the most load - PHP, Perl, and so on. MySQL load data are listed inside an individual section in which you can see all the queries on a per hour, everyday, etcetera. basis. You can go back and compare stats from different months to see if some update has transformed the resource usage if the amount of website visitors has not changed much. That way, you can see if your 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
If you need to see detailed stats for the load generated by your sites, it will not take more than several clicks to do that. The Hepsia hosting CP, which comes with all
semi-dedicated servers we offer, features a section devoted to the system resource usage and the information there shall tell you if your sites operate properly and if the load they produce corresponds to the number of received site visitors. The CPU load stats include the script execution time and the amount of time it took for the server to process the requests, and what sorts of processes generated the load. The MySQL data shall show you how often each database was accessed, as well as everyday and per hour stats for the whole account. With both sorts of statistics, you'll be able to check the numbers for every one of the past days and months, so you could see how the sites perform as the traffic to them increases or after you have applied some update.