MySQL & Load Stats
What kind of information is accessible in the MySQL & Load Stats section? How could you make use of it?
If you have an HTML website, most likely it uses a small amount of system resources due to the fact that it's static, but this isn't the situation with dynamic database-driven Internet sites that use PHP scripts and provide you with much more features. This kind of websites produce load on the website hosting server every time anyone browses them, due to the fact that the hosting server needs time to execute the script, to access the database and then to deliver the info requested by the visitor's browser. A famous discussion board, for instance, 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 word. If lots of people access the forum all at once, or if each and every search involves checking hundreds of thousands of database entries, this can create high load and affect the overall performance of the Internet site. In this regard, CPU and MySQL load data can give you information about the site’s performance, as you can compare the numbers with your traffic statistics to decide if the site needs to be optimized or moved to another sort of website hosting platform which will be able to bear the high system load if the Internet site is extremely popular.
-
MySQL & Load Stats in Cloud Hosting
Using the Hepsia Control Panel, which comes with all of our
cloud hosting plans, you'll be able to see incredibly detailed data regarding the system resources that your Internet sites use. One of the sections shall give you details about the CPU load, like the amount of processing time the server spent, the length of time it took for your scripts to be executed and exactly how much memory they used. Statistics are automatically produced every 6 hours and you could also see the different types of processes that produced the most load - PHP, Perl, etc. MySQL load data are listed within a separate section in which you'll be able to see all the queries on a per hour, day-to-day, and so on. basis. You can go back and compare stats from various months to determine if some update has altered the resource usage if the number of site visitors hasn't changed much. This way, you can see if your Internet site needs to be optimized, that'll give you a better general performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Servers
Our system creates detailed stats about both different kinds of load, so if you buy a
semi-dedicated server for your websites, you can access the info with just a few mouse clicks in your Hepsia hosting CP. Each type of data is listed in its own section. The CPU Load section will show you what processes produced the load and the length of time it took for the hosting server to execute all of the requests. Although stats are generated every six hours, you can see day by day and per month statistics too. In the MySQL Load section you shall find a list of all the databases produced in your semi-dedicated account manually and automatically, what number of queries were sent to each of them, the total everyday queries for the account overall, as well as the average per hour rate. This information will help you see how well your websites perform and if any of them needs optimization of some sort.