MySQL & Load Stats
What kind of info is provided in the MySQL & Load Stats section? How could you take advantage of it?
The CPU load depends upon the length of time a hosting server spends executing a script any time a visitor opens a webpage on a particular script-driven website. Static HTML sites use hardly any CPU time, but it's not so with the far more sophisticated and functional scripts, which use a database and display dynamic content. The more clients open this type of a site, the more load shall be generated on the web server and if the database is large, the MySQL server shall be loaded too. An example of what may cause high load is an online store with a huge number of products. If it is popular, many people shall be browsing it concurrently and if they search for items, the whole database that contains all of the products will also be constantly accessed by the script, which will result in high load. In this light, having CPU and MySQL load data can provide an idea of how the website is doing, if it has to be optimized or if you simply need a more powerful web hosting solution - if the site is really popular and the current setup cannot deal with the load.
-
MySQL & Load Stats in Hosting
Using the Hepsia CP, provided with all of our
hosting packages, you'll be able to see incredibly comprehensive statistics concerning the system resources which your sites use. One of the sections shall give you details about the CPU load, such as how much processing time the server spent, the span of time it took for your scripts to be executed and exactly how much memory they used. Stats are consistently created every six hours and you can also see the different kinds of processes that produced the most load - PHP, Perl, etc. MySQL load statistics are listed inside a separate section where you could see all the queries on a per hour, daily, etc. basis. You can go back and compare statistics from different months to find out whether some update has transformed the resource usage if the total amount of site visitors hasn't changed much. This way, you can determine if your site needs to be optimized, that will result in a better functionality and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Servers
Because our system keeps in depth stats for the load that each
semi-dedicated server account produces, you will be aware of how your sites perform at any time. When you log in to the Hepsia Control Panel, supplied 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 kinds of processes generated the load - cron jobs, PHP pages, Perl scripts, and so forth. You can also see the total number of queries to each database in your semi-dedicated account, the total everyday stats for the account altogether, as well as the average hourly rate. With both the CPU and the MySQL load data, you could always go back to past days or months and examine the overall performance of your sites after some update or after a considerable rise in the number of your site visitors.