MySQL & Load Stats
What kind of info is accessible in the MySQL & Load Stats section? How do you make use of it?
If you have an HTML site, most likely it uses a small amount of resources as it is static, but this isn't the situation with dynamic database-driven websites that use PHP scripts and provide you with a lot more functions. This type of websites generate load on the hosting server when anyone browses them, since 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 famous discussion board, for example, 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 given term. If lots of people access the forum at the same time, or if every single search involves checking tens of thousands of database entries, this can create high load and affect the performance of the site. In this regard, CPU and MySQL load data can present you with information about the site’s performance, as you can compare the numbers with your traffic stats to decide if the Internet site needs to be optimized or moved to another sort of website hosting platform that will be able to bear the high system load if the website is very popular.
-
MySQL & Load Stats in Cloud Website Hosting
Using the Hepsia Control Panel, bundled with all our
cloud website hosting packages, you shall be able to to see really comprehensive statistics regarding the system resources which your sites use. One of the sections will give you information about the CPU load, such as how much processing time the server spent, how much time it took for your scripts to be executed and exactly how much memory they used. Stats are automatically created every 6 hours and you can also see the kinds of processes that generated the most load - PHP, Perl, and so forth. MySQL load stats are listed in a different section where you can see all the queries on an hourly, day-to-day, etc. basis. You can go back and compare data from different months to determine if some update has altered the resource usage if the number of visitors hasn't changed much. In this way, you can determine if your Internet site needs to be optimized, that will lead to a better general performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you need to see thorough statistics about the load produced by your websites, it won't take more than several clicks to do this. The Hepsia hosting CP, provided with all
semi-dedicated servers we offer, features a section devoted to the system resource usage and the data there can tell you if your Internet sites perform well and if the load they create corresponds to the amount of received site visitors. The CPU load data include the script execution time and the length of time it took for the hosting server to process the requests, as well as what types of processes created the load. The MySQL statistics shall show you how frequently each database was accessed, as well as everyday and hourly stats for the whole account. With both kinds of stats, you'll be able to check the numbers for every one of the past days and months, so you can see how sites perform as the traffic to them increases or once you've applied some update.