MySQL & Load Stats
What sort of data is available in the MySQL & Load Stats section? How do you take advantage of it?
If you have an HTML Internet site, in all probability it uses a small amount of resources simply because it is static, but this isn't the situation with dynamic database-driven websites that use PHP scripts and offer a lot more features. This sort of websites produce load on the web hosting server anytime someone browses them, because the hosting server requires time to execute the script, to access the database and then to provide the info requested by the visitor's web browser. A famous discussion board, as an illustration, stores all usernames and posts inside a database, so some load is generated any time a thread is opened or an end user looks for a certain term. If a lot of people access the forum all at once, or if every search involves checking a large number of database entries, this could produce high load and affect the overall performance of the site. In this regard, CPU and MySQL load stats can give you information about the site’s functionality, as you can compare the numbers with your traffic statistics to make a decision if the website has to be optimized or migrated to a different kind of website hosting platform that'll be able to bear the high system load in the event that the website is very popular.
MySQL & Load Stats in Shared Web Hosting
If you host your Internet sites within a shared web hosting
account with us, you will have access to in depth CPU and MySQL stats that will permit you to keep track of their performance. You can see the statistics with a few clicks within your Hepsia Control Panel. The CPU Load section will show you the total time frame the hosting server spent on your scripts and the amount of memory was needed, and the time it took for the scripts to be executed. The day-to-day view is the default one, but you'll be able to also see the numbers from the past months. The MySQL Load section will provide you with additional information about the total amount of queries to each and every database that you have created within the account. Once again, you can easily see per month, daily and hourly stats, that will give you information that's different from the traffic or the number of visitors that you get. This way, you can see if the Internet sites require some optimization.
MySQL & Load Stats in Semi-dedicated Hosting
If you need to see in depth stats about the load produced by your sites, it won't take more than just a few clicks to do this. The Hepsia hosting Control Panel, which comes with all semi-dedicated servers
that we offer, has a section committed to the system resource usage and the data there will tell you if your Internet sites operate properly and if the load they generate corresponds to the total amount of received site visitors. The CPU load statistics include the script execution time and how much time it took for the machine to process the requests, plus what types of processes generated the load. The MySQL statistics will show you how often each individual database was accessed, plus day-to-day and per hour stats for the whole account. With both kinds of stats, you are 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 increases or once you've applied some update.