MySQL & Load Stats
What kind of info is available in the MySQL & Load Stats section? How do you take full advantage of it?
If you have an HTML website, most likely it uses a small amount of resources as it is static, but this isn't so with dynamic database-driven Internet sites that use PHP scripts and provide much more functions. Such websites produce load on the hosting server each time somebody browses them, as the hosting server requires time to execute the script, to access the database and then to supply the content requested by the visitor's Internet browser. A well-known discussion board, for example, stores all usernames and posts within a database, so some load is created every single time a thread is opened or an end user searches for a specific term. If many people access the forum at the same time, or if every single search involves checking hundreds of thousands of database entries, this can produce high load and affect the performance of the Internet site. In this regard, CPU and MySQL load stats can give you data about the site’s functionality, as you can compare the numbers with your traffic stats to make a decision if the site has to be optimized or transferred to a new kind of hosting platform that will be able to bear the high system load if the site is extremely popular.
-
MySQL & Load Stats in Cloud Hosting
If you host your sites within a
cloud hosting account with us, you'll have access to in depth CPU and MySQL statistics that will enable you to keep an eye on their operation. You can see the data with a couple of clicks within your Hepsia CP. The CPU Load section will reveal to you the total time period the web server spent on your scripts and how much memory was needed, along with the time it took for the scripts to be executed. The everyday view is the default one, but you are able to also see the stats from the previous months. The MySQL Load section give you more details about the total amount of queries to each database that you have set up inside the account. Once again, you are able to see month-to-month, daily and per hour stats, that will give you data which is different from the traffic or the number of visitors that you get. In this way, you can identify if the websites need some optimization.
-
MySQL & Load Stats in Semi-dedicated Hosting
As our system keeps detailed statistics for the load that every
semi-dedicated server account generates, you will be aware of how your Internet sites perform at any time. As soon as you log in to the Hepsia Control Panel, which comes with every account, you can check out the section committed to the system load. There, you will see the processing time our system spent on your scripts, the span of time it took for the scripts to be actually executed and what types of processes produced the load - cron jobs, PHP pages, Perl scripts, etc. You may also see the amount of queries to every single database inside your semi-dedicated account, the total everyday stats for the account in general, and also the average hourly rate. With both the CPU and the MySQL load data, you can always go back to past days or months and evaluate the functionality of your websites after some update or after a sizeable rise in the number of your website visitors.